Query dba_role_privs table : dba_role_privs « System Tables Views « Oracle PL / SQL






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

1.Query user granted roles
2.Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Name of the object, Privilege granted,Was admin option granted
3.Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Recipient of the grant,Owner of the object