SYS.USER_TAB_PRIVS

The USER_TAB_PRIVS view lists the object privileges granted to the current user, the object privileges granted by the current user, and the list of object privileges granted for objects owned by the current user.

Related views

• SYS.ALL_TAB_PRIVS

• SYS.DBA_TAB_PRIVS

Columns

Column name	Type	Description
GRANTEE	VARCHAR2(30) INLINE	Name of the user with the privilege
OWNER	VARCHAR2(30) INLINE	Object owner
TABLE_NAME	VARCHAR2(30) INLINE	Object name
GRANTOR	VARCHAR2(30) INLINE	Name of the user who granted the privilege
PRIVILEGE	VARCHAR2(40) INLINE NOT NULL	Privilege name
GRANTABLE	VARCHAR2(3) INLINE NOT NULL	Value NO
HIERARCHY	VARCHAR2(3) INLINE NOT NULL	Value NO