Home » RDBMS Server » Server Administration » ALTER USER...... ADMIN OPTION
ALTER USER...... ADMIN OPTION [message #2218] Fri, 28 June 2002 10:03 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Hello All,

I have a question about altering a user to give them the admin option on a role.

They already have the role and I want to give them the admin option. I can't really drop the user and recreate them and then grant them the role with the admin option, because they have a bunch of other roles aswell. Any suggestions?

Thanx
~T~
Re: ALTER USER...... ADMIN OPTION [message #2219 is a reply to message #2218] Fri, 28 June 2002 10:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i believe you can just grant the role again with admin option.

grant old_role to old_user with admin_option;
Previous Topic: PROBLEM ON maximum of 20 enabled roles exceeded
Next Topic: substr on LONG datatype
Goto Forum:
  


Current Time: Tue Sep 17 20:30:46 CDT 2024