Roles & Privs

HOWTO check roles:

to get the role name:

SELECT * FROM sys.dba_roles

to find privileges granted to a role:

SELECT * FROM ROLE_ROLE_PRIVS WHERE role in ('CONNECT')

SELECT * FROM ROLE_SYS_PRIVS WHERE role in ('CONNECT')

SELECT * FROM ROLE_TAB_PRIVS WHERE role in ('CONNECT')

select GRANTEE,TABLE_NAME,PRIVILEGE from dba_tab_privs where owner=<USERNAME>

select GRANTEE,TABLE_NAME,PRIVILEGE from dba_tab_privs where grantee =<USERNAME>

select granted_role,grantee from dba_role_privs

where grantee not in('SYS','SYSTEM')

check tables privileges granted to a role.

select GRANTEE,TABLE_NAME,PRIVILEGE from dba_tab_privs where grantee=<USERNAME>