Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant alter user for specific users

cayatesJan 29 2007 — edited Jan 29 2007
Hello,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2007
Added on Jan 29 2007
4 comments
4,509 views