OraFAQ Forum: Security » Privilege require

Home » RDBMS Server » Security » Privilege require - creation of user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Privilege require - creation of user [message #64548]

Mon, 07 February 2005 07:41

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

Report message to a moderator

Re: Privilege require - creation of user [message #64554 is a reply to message #64548]

Mon, 07 February 2005 23:20

Frank Naude
Messages: 4587
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 23:42:28 CST 2025