Subject | Can another User besides SYSDBA add and delete users? |
---|---|
Author | westley52 |
Post date | 2007-10-24T08:44:14Z |
For security reasons, I wish to create a user whose sole
responsibility is to create, update, or delete users. I do not wish
this user to have any other power over the server's databases - hence
I am hesitant to allow this user to use the "SYSDBA" account.
However, in any documentation that I have read, I have not found that
SYSDBA could assign the rights to create/delete users to another user.
Is it possible? If so, how is it done?
Thanks for any help.
responsibility is to create, update, or delete users. I do not wish
this user to have any other power over the server's databases - hence
I am hesitant to allow this user to use the "SYSDBA" account.
However, in any documentation that I have read, I have not found that
SYSDBA could assign the rights to create/delete users to another user.
Is it possible? If so, how is it done?
Thanks for any help.