[Home] [Help]
[Dependency Information]
VIEW: SYS.DBA_ROLE_PRIVS
Object Details
Object Name: | DBA_ROLE_PRIVS |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Roles granted to users and roles
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
GRANTEE |
VARCHAR2 |
(128) |
|
Grantee Name, User or Role receiving the grant |
GRANTED_ROLE |
VARCHAR2 |
(128) |
|
Granted role name |
ADMIN_OPTION |
VARCHAR2 |
(3) |
|
Grant was with the ADMIN option |
DELEGATE_OPTION |
VARCHAR2 |
(3) |
|
Grant was with the DELEGATE option |
DEFAULT_ROLE |
VARCHAR2 |
(3) |
|
Role is designated as a DEFAULT ROLE for the user |
COMMON |
VARCHAR2 |
(3) |
|
Role was granted commonly |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT GRANTEE
, GRANTED_ROLE
, ADMIN_OPTION
, DELEGATE_OPTION
, DEFAULT_ROLE
, COMMON
FROM SYS.DBA_ROLE_PRIVS;
Dependencies
[top of page]
SYS.DBA_ROLE_PRIVS references the following:
-
SYS
-
DEFROLE$
-
SYSAUTH$
-
USER$
SYS.DBA_ROLE_PRIVS is referenced by following:
-
CTXSYS
-
DRIACC
- show dependent code
-
DVSYS
-
DBMS_MACUTL
- show dependent code
-
DV_ADMIN_GRANTEES
-
DV_AUDIT_CLEANUP_GRANTEES
-
DV_MONITOR_GRANTEES
-
DV_OWNER_GRANTEES
-
DV_SECANALYST_GRANTEES
-
GSMADMIN_INTERNAL
-
DBMS_GSM_NOPRIV
- show dependent code
-
PUBLIC
-
DBA_ROLE_PRIVS
-
SYS
-
ALL_GOLDENGATE_PRIVILEGES
-
ALL_XSTREAM_ADMINISTRATOR
-
DBA_CONNECT_ROLE_GRANTEES
-
DBMSOBJG
- show dependent code
-
DBMS_CDC_IPUBLISH
- show dependent code
-
DBMS_CMP_INT
- show dependent code
-
DBMS_FEATURE_IDH
- show dependent code
-
DBMS_FEATURE_RAS
- show dependent code
-
DBMS_LOGREP_UTIL
- show dependent code
-
DBMS_REPCAT_ADMIN
- show dependent code