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.
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 --