Grant alter user for specific users
cayatesJan 29 2007 — edited Jan 29 2007Hello,
We have a database that we would like to share with another agency. This agency has an employee that will need the ability to change the passwords of her agencies employees.
However, she should not be able to alter any other users which are not in her agency. As far as I can tell, if I do a "GRANT ALTER USER" to this user, she can then change anybodies passwords, including dba's, etc.
How can I give one user the ability to change passwords of only a specified list of user accounts?
Thanks.