5 Replies Latest reply: Jan 16, 2013 5:30 AM by Rob_J RSS

    all users privs

    user522961
      Hi,
      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 ?
      Thank you.
        • 1. Re: all users privs
          EdStevens
          user522961 wrote:
          Hi,
          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 ?
          Thank you.
          Check the index of the Reference Manual, [url http://docs.oracle.com/cd/E11882_01/server.112/e25513/index.htm] Here

          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.
          • 2. Re: all users privs
            SomeoneElse
            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%';
            • 3. Re: all users privs
              Mark D Powell
              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 ?
              http://www.jlcomp.demon.co.uk/faq/privileges.html


              Both system privileges and object privileges can be obtained via roles and the article also lists role views.

              HTH -- Mark D Powell --
              • 4. Re: all users privs
                Osama_Mustafa
                For Object Privileges :
                 USER_TAB_PRIVS
                ALL_TAB_PRIVS
                ROLE_TAB_PRIVS
                DBA_TAB_PRIVS
                System Privileges
                all_sys_privs
                session_privs
                user_sys_privs
                dba_sys_privs
                system_privilege_map
                • 5. Re: all users privs
                  Rob_J
                  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.