USER_TAB_PRIVS

The USER_TAB_PRIVS view provides information about the 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 whom access was granted to.
OWNER VARCHAR2(128) The owner of the object.
TABLE_NAME VARCHAR2(128) The name of the object.
The object can be any object, including tables, packages, indexes, sequences, and others.
GRANTOR VARCHAR2(128) The name of the user who performed the grant.
PRIVILEGE VARCHAR2(40) The privilege on the object.
GRANTABLE VARCHAR2(3) Specifies whether the privilege was granted with the GRANT OPTION (YES) or not (NO).
HIERARCHY VARCHAR2(3) Specifies whether the GRANTEE has the REFERENCES privilege with the HIERARCHY OPTION on all subobjects of the specified table.
The possible values are:
  • YES - The privilege is granted to the table and its dependent objects.
  • NO - The privilege is granted only to the table.

Always NO, NOT NULL, INLINE
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.
TYPE VARCHAR2(24) The type of the object.
INHERITED VARCHAR2(3) Specifies whether the privilege grant was inherited from another container (YES) or not (NO).