Adminstration-Role

Adminstration-Role

Find a role

select *
from dba_roles
where role like '&role'
/

Show what roles are granted to a user

select grantee
, granted_role
, admin_option
from dba_role_privs
where grantee like upper('&username')
/

Show what system privileges are granted to a role

select privilege
, admin_option
from role_sys_privs
where role like '&role'
/

Show what table privileges are granted to a role

select owner || '.' || table_name "TABLE"
, column_name
, privilege
, grantable
from role_tab_privs
where role like '&role'
/