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: 68624
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: Thu Mar 28 03:50:13 CDT 2024