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>