ALL_COL_PRIVS

The ALL_COL_PRIVS view provides information about column-level object grants where the current user is the object owner, grantor, grantee, or where an enabled role or PUBLIC is the grantee.

Column name Data type Description
GRANTOR VARCHAR2(128) The name of the user who performed the grant.
GRANTEE VARCHAR2(128) The name of the user or role to whom access was granted.
TABLE_SCHEMA VARCHAR2(128) The schema of the object.
TABLE_NAME VARCHAR2(128) The name of the object.
COLUMN_NAME VARCHAR2(128) The name of the column.
PRIVILEGE VARCHAR2(40) The privilege on the column.
The possible values are:
  • INSERT
  • REFERENCES
  • UPDATE
GRANTABLE VARCHAR2(3) Specifies whether the privilege was granted with the
GRANT OPTION (YES) or not (NO).
COMMON VARCHAR2(3) Specifies how the privilege was granted. The possible values are:
  • YES - The privilege was granted commonly.
  • NO - The privilege was granted locally.
INHERITED VARCHAR2(3) Specifies whether the privilege grant was inherited from another container (YES) or not (NO).