Home » RDBMS Server » Security » What roles for creating/modifying users and roles
What roles for creating/modifying users and roles [message #393191] Fri, 20 March 2009 12:26 Go to next message
roithi
Messages: 8
Registered: March 2006
Junior Member
Hi guys!

What roles does my user need, if the user should be able to
log in to the Oracle Enterprise Manager,
create users
create roles
edit and delete users and roles he created
grant object privilegs to roles and users


thanks for your help!

Re: What roles for creating/modifying users and roles [message #393195 is a reply to message #393191] Fri, 20 March 2009 13:02 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To connect to OEM: SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY.
For the rest, just read SQL Reference, each statement page give the prerequisites.

Regards
Michel

Previous Topic: Grant Unlock User
Next Topic: How to trace which user causing the account lock + auditing failed login via application server (mer
Goto Forum:
  


Current Time: Tue Dec 06 08:19:47 CST 2016

Total time taken to generate the page: 0.08771 seconds