USER_TAB_PRIVS v12

The USER_TAB_PRIVS view provides a listing of the object privileges for which a current user is either an object owner, grantor, or grantee.

NameTypeDescription
granteeCHARACTER VARYING(128)Name of the user with the privilege.
ownerCHARACTER VARYING(128)Object owner.
schema_nameCHARACTER VARYING(128)Name of the schema in which the object resides.
table_nameCHARACTER VARYING(128)Object name.
grantorCHARACTER VARYING(128)Name of the user who granted the privilege.
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.