Static Data Dictionary Views, 9 of 452

ALL_COL_PRIVS

ALL_COL_PRIVS describes column object grants for which the current user or PUBLIC is the object owner, grantor, or grantee. This view displays OWNER but not TABLE_SCHEMA.

Related views:

DBA_COL_PRIVS describes all column object grants in the database. This view displays OWNER but not TABLE_SCHEMA.

USER_COL_PRIVS describes column object grants for which the current user is the object owner, grantor, or grantee. This view displays TABLE_SCHEMA but not OWNER.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object. Displayed only in the DBA_ and USER_ views.

GRANTOR

VARCHAR2(30)

NOT NULL

Name of the user who performed the grant

GRANTEE

VARCHAR2(30)

NOT NULL

Name of the user to whom access was granted

TABLE_SCHEMA

VARCHAR2(30)

NOT NULL

Schema of the object. Displayed only in the ALL_ view.

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column

PRIVILEGE

VARCHAR2(40)

NOT NULL

Privilege on the column

GRANTABLE

VARCHAR2(3)

Whether privileges were granted with ADMIN OPTION (YES or NO)

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object. Displayed only in the `DBA_` and `USER_` views.
`GRANTOR`	`VARCHAR2(30)`	`NOT NULL`	Name of the user who performed the grant
`GRANTEE`	`VARCHAR2(30)`	`NOT NULL`	Name of the user to whom access was granted
`TABLE_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Schema of the object. Displayed only in the `ALL_` view.
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object
`COLUMN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the column
`PRIVILEGE`	`VARCHAR2(40)`	`NOT NULL`	Privilege on the column
`GRANTABLE`	`VARCHAR2(3)`		Whether privileges were granted with ADMIN OPTION (YES or NO)