ALL_TAB_PRIVS v12

The ALL_TAB_PRIVS view provides the following types of privileges:

  • Object privileges for which a current user is either an object owner, grantor, or grantee.
  • Object privileges for which the 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.
privilegeCHARACTER VARYING(40)Privilege name.
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 in turn grant the privilege to others. The value may be YES if the grantee has the administrator privileges.
hierarchyCHARACTER VARYING(3)The value can be YES or NO. The value may be YES if the privilege is SELECT else NO.
commonCHARACTER VARYING(3)Included for compatibility only; always NO.
typeCHARACTER VARYING(24)Type of object.
inheritedCHARACTER VARYING(3)Included for compatibility only; always NO.