Home » RDBMS Server » Security » Privilege require - creation of user
Privilege require - creation of user [message #64548] Mon, 07 February 2005 07:41 Go to next message
Asif Khan
Messages: 9
Registered: November 2000
Junior Member
I have to create an oracle databae users as an admin, and assigning appropriate role(s) from web.

What privilege I should have to create a user ?

Thanks
Re: Privilege require - creation of user [message #64554 is a reply to message #64548] Mon, 07 February 2005 23:20 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Try the following:

SQL> GRANT CREATE USER TO scott;

Grant succeeded.

SQL> GRANT GRANT ANY ROLE TO scott;

Grant succeeded.


Best regards.

Frank
Previous Topic: How to find passwords of all users ?
Next Topic: SYS password
Goto Forum:
  


Current Time: Thu Mar 28 10:26:53 CDT 2024