USER_TAB_PRIVS v17
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.
| Name | Type | Description |
|---|---|---|
grantee | CHARACTER VARYING(128) | Name of the user with the privilege. |
owner | CHARACTER VARYING(128) | Object owner. |
schema_name | CHARACTER VARYING(128) | Name of the schema in which the object resides. |
table_name | CHARACTER VARYING(128) | Object name. |
grantor | CHARACTER VARYING(128) | Name of the user who granted the privilege. |
privilege | CHARACTER VARYING(40) | Privilege name. |
grantable | CHARACTER 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 grant the privilege to others. The value can be YES if the grantee has administrator privileges. |
hierarchy | CHARACTER VARYING(3) | The value can be YES or NO. The value can be YES if the privilege is SELECT. Otherwise the value is NO. |
common | CHARACTER VARYING(3) | Included only for compatibility. Always NO. |
type | CHARACTER VARYING(24) | Type of object. |
inherited | CHARACTER VARYING(3) | Included only for compatibility. Always NO. |