how to see privileges assigned to a role?

Hi,

Which db dictionary view should I query to find what kind of system and object privileges have seen granted to certain role?

Thanks!

DBA_SYS_PRIVS
DBA_TAB_PRIVS

if you have access to the above views

Thanks,
Madhu

You should look at these three tables:

SQL> desc role_sys_privs;
Name Null? Type
------------------------------- -------- ----
ROLE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)

SQL> desc role_tab_privs;
Name Null? Type
------------------------------- -------- ----
ROLE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)

SQL> desc role_role_privs;
Name Null? Type
------------------------------- -------- ----
ROLE NOT NULL VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)