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

VIEW: SYS.ALL_COL_PRIVS

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

Grants on columns for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee

[View Source]

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

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


SELECT GRANTOR
,      GRANTEE
,      TABLE_SCHEMA
,      TABLE_NAME
,      COLUMN_NAME
,      PRIVILEGE
,      GRANTABLE
,      COMMON
FROM SYS.ALL_COL_PRIVS;

Dependencies

[top of page]

SYS.ALL_COL_PRIVS references the following:

SchemaSYS
TableCOL$
TableOBJAUTH$
TableTABLE_PRIVILEGE_MAP
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.ALL_COL_PRIVS is referenced by following:

SchemaPUBLIC
SynonymALL_COL_PRIVS