Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> --