ALL_COL_PRIVS v16

The ALL_COL_PRIVS view provides the following types of privileges:

  • Column object privileges for which a current user is either an object owner, grantor, or grantee.
  • Column object privileges for which PUBLIC is the grantee.
NameTypeDescription
grantorCHARACTER VARYING(128)Name of the user who granted the privilege.
granteeCHARACTER VARYING(128)Name of the user with the privilege.
table_schemaCHARACTER VARYING(128)Name of the user who owns the object.
schema_nameCHARACTER VARYING(128)Name of the schema in which the object resides.
table_nameCHARACTER VARYING(128)Object name.
column_nameCHARACTER VARYING(128)Column name.
privilegeCHARACTER VARYING(40)Privilege on the column.
grantableCHARACTER VARYING(3)Indicates whether the privilege was granted with the grant option YES or NO. YES indicates that the GRANTEE (recipient of the privilege) can grant the privilege to others. The value can be YES if the grantee has administrator privileges.
commonCHARACTER VARYING(3)Included for compatibility only. Always NO.
inheritedCHARACTER VARYING(3)Included for compatibility only. Always NO.