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

VIEW: SYS.CDB_COL_PRIVS

Object Details
Object Name: CDB_COL_PRIVS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All grants on columns in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
GRANTEE VARCHAR2 (128)
Name of the user to whom access was granted
OWNER VARCHAR2 (128)
Username of the owner of the object
TABLE_NAME VARCHAR2 (128)
Name of the object
COLUMN_NAME VARCHAR2 (128)
Name of the column
GRANTOR VARCHAR2 (128)
Name of the user who performed the grant
PRIVILEGE VARCHAR2 (40)
Column Privilege
GRANTABLE VARCHAR2 (3)
Privilege is grantable
COMMON VARCHAR2 (3)
Privilege was granted commonly
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GRANTEE
,      OWNER
,      TABLE_NAME
,      COLUMN_NAME
,      GRANTOR
,      PRIVILEGE
,      GRANTABLE
,      COMMON
,      CON_ID
FROM SYS.CDB_COL_PRIVS;

Dependencies

[top of page]

SYS.CDB_COL_PRIVS does not reference any database object

SYS.CDB_COL_PRIVS is referenced by following:

SchemaPUBLIC
SynonymCDB_COL_PRIVS