This content has been marked as final. Show 6 replies
-- You will get the list of system privileges.
For object privilege its depends upon your object in the database.
This table SYSTEM_PRIVILEGE_MAP simply lists privlege names. I am looking for elaborative description for each privilege and role(standard out of the box roles).Thanks -R
Rich V wrote:Hi, you can use dba_role_privs,role_sys_privs views,for more information see
I am looking for a comprehensive details about each and every role, privileges(both object and system) that are available in standard Oracle EE 10g r2.
I have visited administrator reference manual and other documents from docs.oracle.com but could not fine this information.
Can anyone redirect me to an appropriate URL or documentation that details whats and hows of each and every roles and privileges?
The documentation for SQL statement GRANT should list every system privilege, object privilege and predefined role: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9013.htm#i2155015.
Thank you Chinar and Thank you P.Forstmann. Documentation links you have provided gives comprehensive information. Which, is exactly what I needed.
to find general information about roles,privilege, users and users roles and privileges queries.
Users, roles and privileges in Oracle
Listing privileges recursively for Oracle users:
hope this will helps you.