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 | NO)