Query dba_role_privs table : dba_role_privs « System Tables Views

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


  

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

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.