[Home] [Help]
[Dependency Information]
VIEW: SYS.DBA_SYS_PRIVS
Object Details
Object Name: | DBA_SYS_PRIVS |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
System privileges granted to users and roles
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
GRANTEE |
VARCHAR2 |
(128) |
|
Grantee Name, User or Role receiving the grant |
PRIVILEGE |
VARCHAR2 |
(40) |
|
System privilege |
ADMIN_OPTION |
VARCHAR2 |
(3) |
|
Grant was with the ADMIN option |
COMMON |
VARCHAR2 |
(3) |
|
Privilege is common |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT GRANTEE
, PRIVILEGE
, ADMIN_OPTION
, COMMON
FROM SYS.DBA_SYS_PRIVS;
Dependencies
[top of page]
SYS.DBA_SYS_PRIVS references the following:
-
SYS
-
SYSAUTH$
-
SYSTEM_PRIVILEGE_MAP
-
USER$
SYS.DBA_SYS_PRIVS is referenced by following:
-
CTXSYS
-
DRIACC
- show dependent code
-
DVSYS
-
DBMS_MACUTL
- show dependent code
-
PUBLIC
-
DBA_SYS_PRIVS
-
SYS
-
DBMS_SQL_TRANSLATOR_EXPORT
- show dependent code
-
ISXMLTYPETABLE