Home » SQL & PL/SQL » SQL & PL/SQL » Re: ALTER USER...... ADMIN OPTION
Re: ALTER USER...... ADMIN OPTION [message #2229] Sun, 30 June 2002 23:25
Rajeev Dhingra
Messages: 5
Registered: June 2002
Junior Member
There is no need to drop the user, if you just want the user to give the privilege to grant some specific role with grant option. Even there is no need to give an ALTER USER command. You just need to re-grant the role to the user with admin option. By doing that specific user will be able to grant that role to further users...

Report message to a moderator

Previous Topic: how can I get the full date data?
Next Topic: Storing an Image File in Oracle 8i and retrieving onto a Form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 14:54:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.