[Home] [Help]
[Dependency Information]
VIEW: DVSYS.DBA_DV_USER_PRIVS_ALL
Object Details
Object Name: | DBA_DV_USER_PRIVS_ALL |
Object Type: | VIEW |
Owner: | DVSYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
USERNAME |
VARCHAR2 |
(128) |
|
|
ACCESS_TYPE |
VARCHAR2 |
(128) |
|
|
PRIVILEGE |
VARCHAR2 |
(40) |
|
|
OWNER |
VARCHAR2 |
(128) |
|
|
OBJECT_NAME |
VARCHAR2 |
(128) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT USERNAME
, ACCESS_TYPE
, PRIVILEGE
, OWNER
, OBJECT_NAME
FROM DVSYS.DBA_DV_USER_PRIVS_ALL;
Dependencies
[top of page]
DVSYS.DBA_DV_USER_PRIVS_ALL references the following:
-
SYS
-
OBJ$
-
OBJAUTH$
-
SYSAUTH$
-
SYSTEM_PRIVILEGE_MAP
-
TABLE_PRIVILEGE_MAP
-
USER$
DVSYS.DBA_DV_USER_PRIVS_ALL is referenced by following:
-
PUBLIC
-
DBA_DV_USER_PRIVS_ALL