Checking Object Privileges Received

user_tab_privs_recd table stores object privileges a user has received.

The columns in user_tab_privs_recd:

Column	Type	Description
owner	VARCHAR2(30)	User who owns the object
table_name	VARCHAR2(30)	Name of the object on which the privilege was granted
grantor	VARCHAR2(30)	User who granted the privilege
privilege	VARCHAR2(40)	Privilege on the object
grantable	VARCHAR2(3)	Whether the grantee can grant the privilege to another (YES or NO)
hierarchy	VARCHAR2(3)	Whether the privilege forms part of a hierarchy (YES or NO)


SELECT * FROM user_tab_privs_recd ORDER BY privilege;

user_col_privs_recd stores column object privileges a user has received.

The columns in user_col_privs_recd:

Column	Type	Description
owner	VARCHAR2(30)	User who owns the object
table_name	VARCHAR2(30)	Name of the table on which the privilege was granted
column_name	VARCHAR2(30)	Name of the column on which the privilege was granted
grantor	VARCHAR2(30)	User who granted the privilege
privilege	VARCHAR2(40)	Privilege on the object
grantable	VARCHAR2(3)	Whether the grantee can grant the privilege to another (YES or NO)


SELECT * FROM user_col_privs_recd;

Object Privileges: