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

Home
Oracle PL / SQL
1.Aggregate Functions
2.Analytical Functions
3.Char Functions
4.Constraints
5.Conversion Functions
6.Cursor
7.Data Type
8.Date Timezone
9.Hierarchical Query
10.Index
11.Insert Delete Update
12.Large Objects
13.Numeric Math Functions
14.Object Oriented Database
15.PL SQL
16.Regular Expressions
17.Report Column Page
18.Result Set
19.Select Query
20.Sequence
21.SQL Plus
22.Stored Procedure Function
23.Subquery
24.System Packages
25.System Tables Views
26.Table
27.Table Joins
28.Trigger
29.User Previliege
30.View
31.XML
Oracle PL / SQL » System Tables Views » dba_role_privs 
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_optionwadmin
  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
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.