This content has been marked as final. Show 5 replies
user522961 wrote:Check the index of the Reference Manual, [url http://docs.oracle.com/cd/E11882_01/server.112/e25513/index.htm] Here
on 11g there is a table that all privileges of all users is indicated. It should be something like dba_privs or like that. I have forgotten the name can you help me please ?
I would say check the contents, but unfortunately, Oracle structured the TOC such that you have to drill down, then step through. Index provides a better lookup in this case.
Whenever you can't remember a dictionary table name (actually a view) just look in the dictionary itself:
SQL> select * from dictionary where table_name like '%PRIV%';
Or you can query DBA_VIEWS like select view_name from dba_views where view_name like 'DBA%PRIV%' which shows 9 views on 10.2.0.5.
Here is a short article that lists most of the views that provide object and system privilege information at the database and session level.
How do I find out which users have the rights, or privileges, to access a given object ?
Both system privileges and object privileges can be obtained via roles and the article also lists role views.
HTH -- Mark D Powell --
For Object Privileges :
USER_TAB_PRIVS ALL_TAB_PRIVS ROLE_TAB_PRIVS DBA_TAB_PRIVS
all_sys_privs session_privs user_sys_privs dba_sys_privs system_privilege_map
Part way down this page on [url http://www.ora00600.com/scripts/security/user_privileges.html]user privileges and roles in Oracle there are some queries for getting the information that you want.