Query dba_role_privs table
SQL>
SQL> set verify off
SQL>
SQL> column grole format a20 heading "Role Granted"
SQL> column wadmin format a6 heading "Admin?"
SQL>
SQL> select granted_role grole, initcap(admin_option) wadmin
2 from dba_role_privs
3 where rownum < 50
4 /
Role Granted Admin?
-------------------- ------
CONNECT No
RESOURCE No
XDBADMIN No
PLUSTRACE Yes
XDBWEBSERVICES No
SCHEDULER_ADMIN Yes
EXP_FULL_DATABASE No
IMP_FULL_DATABASE No
DELETE_CATALOG_ROLE Yes
SELECT_CATALOG_ROLE Yes
EXECUTE_CATALOG_ROLE Yes
GATHER_SYSTEM_STATIS No
TICS
DBA Yes
CTXAPP Yes
CONNECT Yes
RESOURCE Yes
XDBADMIN Yes
PLUSTRACE Yes
OEM_ADVISOR Yes
OEM_MONITOR Yes
AQ_USER_ROLE Yes
HS_ADMIN_ROLE Yes
XDBWEBSERVICES Yes
SCHEDULER_ADMIN Yes
AUTHENTICATEDUSER Yes
EXP_FULL_DATABASE Yes
IMP_FULL_DATABASE Yes
DELETE_CATALOG_ROLE Yes
SELECT_CATALOG_ROLE Yes
EXECUTE_CATALOG_ROLE Yes
AQ_ADMINISTRATOR_ROL Yes
E
LOGSTDBY_ADMINISTRAT Yes
OR
RECOVERY_CATALOG_OWN Yes
ER
GATHER_SYSTEM_STATIS Yes
TICS
CTXAPP No
RESOURCE No
CONNECT No
RESOURCE No
RESOURCE No
CTXAPP Yes
RESOURCE No
OEM_MONITOR No
DBA No
DBA Yes
AQ_ADMINISTRATOR_ROL Yes
E
RESOURCE No
XDBWEBSERVICES No
CONNECT No
RESOURCE No
49 rows selected.
SQL>
SQL> --
Related examples in the same category