reset password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 30 Jul 2008 14:03 GMT

Hi,

Idealy I want to grant helpdesk group "reset password" for sql logins
permission only. Is this possible? Do I have to add them to securityadmin
which can grant, deny etc?

Thanks,
Sarah

Reply to this Message

Tom Moreau - 30 Jul 2008 15:12 GMT

Consider granting the ALTER ANY LOGIN permission to the help desk group.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Hi,

Idealy I want to grant helpdesk group "reset password" for sql logins
permission only. Is this possible? Do I have to add them to securityadmin
which can grant, deny etc?

Thanks,
Sarah

Reply to this Message

Rick Byham, (MSFT) - 30 Jul 2008 16:35 GMT

Or create a stored procedure with the ALTER LOGIN statement and grant them
execute permission to the procedure.

Signature

Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

> Consider granting the ALTER ANY LOGIN permission to the help desk group.
>
[quoted text clipped - 6 lines]
> Thanks,
> Sarah

Reply to this Message

sg - 30 Jul 2008 20:18 GMT

Thanks so much Tom, it works.

> Consider granting the ALTER ANY LOGIN permission to the help desk group.
>
[quoted text clipped - 6 lines]
> Thanks,
> Sarah

Reply to this Message