DBA Data[Home] [Help] [Dependency Information]


VIEW: DVSYS.DBA_DV_USER_PRIVS

Object Details
Object Name: DBA_DV_USER_PRIVS
Object Type: VIEW
Owner: DVSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
USERNAME VARCHAR2 (128) Yes
ACCESS_TYPE VARCHAR2 (128)
PRIVILEGE VARCHAR2 (40) Yes
OWNER VARCHAR2 (128) Yes
OBJECT_NAME VARCHAR2 (128) Yes
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;

Dependencies

[top of page]

DVSYS.DBA_DV_USER_PRIVS references the following:

SchemaSYS
TableOBJ$
TableOBJAUTH$
TableSYSAUTH$
TableTABLE_PRIVILEGE_MAP
TableUSER$
DVSYS.DBA_DV_USER_PRIVS is referenced by following:

SchemaPUBLIC
SynonymDBA_DV_USER_PRIVS