- Administration
- Structure
- Performance
- Backup
- Miscellaneous
- SQL*Net
|
|
Administration - Roles
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'
/
|
|
