USER_COL_PRIVS

The USER_COL_PRIVS view provides information about the column object grants for which the current user is the object owner, grantor, or grantee.

Column name Data type Description
GRANTEE VARCHAR2(128) The name of the user or role to whom access was granted.
OWNER VARCHAR2(128) The owner of the object.
TABLE_NAME VARCHAR2(128) The name of the object.
COLUMN_NAME VARCHAR2(128) The name of the column.
GRANTOR VARCHAR2(128) The name of the user who performed the grant.
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 (CONTAINER=ALL was used).
  • NO - The privilege was granted locally (CONTAINER=ALL was not used).
INHERITED VARCHAR2(3) Specifies whether the privilege grant was inherited from another container (YES) or not (NO).