Re: Change Password Role
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 22 Jun 2007 21:52:39 +0000 (UTC)
Agho (Agho@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Is there a role that I can assign to a user that will give them the
ability to change password for specific group of database users?
Which version of SQL Server are you using?
In SQL 2005, you should be able create a role that you can grant
ALTER LOGIN on the logins, you want the role to be able to change
the passwords for. I don't think you can ALTER LOGIN on a role, but
you will have to grant rights on each login.
If you want users in the role to have the right to change any password,
you can grant the role ALTER ANY LOGIN.
I'm 100% sure that ALTER LOGIN is sufficient; you may need CONTROL LOGIN.
But testing this should be simple.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Login Authentication for Standard Accounts
- Next by Date: Re: 3 Simple Security SQL Statements
- Previous by thread: Login Authentication for Standard Accounts
- Next by thread: Re: 3 Simple Security SQL Statements
- Index(es):
Relevant Pages
|
