SYS.DBA_TAB_PRIVS

The DBA_TAB_PRIVS view lists the object privileges granted to all users and to PUBLIC.

Related views

• SYS.ALL_TAB_PRIVS

• SYS.USER_TAB_PRIVS

Required privileges

ADMIN

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