List of Privileges given to exp_full_database role

Where can i get a list of privileges given to exp_full_database, imp_full_database and dba role?

Is there any table/view which will show all the privileges granted to a role ?

- Milind

For system privileges granted to EXP_FULL_DATABASE role:

select * from dba_sys_privs
where grantee='EXP_FULL_DATABASE';

For other roles granted to EXP_FULL_DATABASE role:

select * from dba_role_privs
where grantee='EXP_FULL_DATABASE';


[Edited by jmodic on 07-19-2002 at 08:53 AM]

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXP_FULL_DATABASE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO YES
EXP_FULL_DATABASE SELECT_CATALOG_ROLE NO YES

jmodic gave me correct answer.

Regarding chao_ping's answer

Ive gone thru roles granted to exp_full_database.
i found at the end both are having same role ie HS_ADMIN_ROLE and it has no privileges.
what does it mean?

check out this o/p


SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXP_FULL_DATABASE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO YES
EXP_FULL_DATABASE SELECT_CATALOG_ROLE NO YES

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXECUTE_CATALOG_ROLE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE NO YES

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='HS_ADMIN_ROLE';

no rows selected

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='SELECT_CATALOG_ROLE';

GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
SELECT_CATALOG_ROLE HS_ADMIN_ROLE NO YES

SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='HS_ADMIN_ROLE';

no rows selected

SQL> select * from dba_sys_privs where grantee='HS_ADMIN_ROLE';

no rows selected