Re: How can I list all the privs of all Roles in an instance?

In article <3AC755EA.644C7AFE_at_acm.org>, Ewin Barnett <ewin_at_acm.org> writes:
>see subject.
>--
>====
>Ewin Barnett, Boone County, Missouri, USA.
>
>"Democracy and socialism have nothing in common but one word:
>equality. But notice the difference: while democracy seeks equality
>in liberty, socialism seeks equality in restraint and servitude."
>--Alexis De Tocqueville

Alex, try looking at the dictionary views with role in their name like sys.dba_sys_privs for system privileges and sys.dba_tab_privs for table privileges. I think the following query will help you.

UT1> select table_name, substr(comments,1,45) as COMMENTS   2 from dictionary
  3 where table_name like '%ROLE%';

TABLE_NAME                     COMMENTS
------------------------------ ---------------------------------------------
DBA_ROLES                      All Roles which exist in the database
DBA_ROLE_PRIVS                 Roles granted to users and roles
USER_ROLE_HIERARCHY
USER_ROLE_PRIVS                Roles granted to current user
ROLE_ROLE_PRIVS                Roles which are granted to roles
ROLE_SYS_PRIVS                 System privileges granted to roles
ROLE_TAB_PRIVS                 Table privileges granted to roles
SESSION_ROLES                  Roles which the user currently has enabled.

8 rows selected.

• Mark D. Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net