Checking Object Privileges Made, user_tab_privs_made and user_col_privs_made

user_tab_privs_made stores object privileges granted. The columns in user_tab_privs_made:

Column	Type	Description
grantee	VARCHAR2(30)	User to whom the privilege was granted
table_name	VARCHAR2(30)	Name of the object (such as a table) 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_made
WHERE table_name = 'EMP';

user_col_privs_made stores column object privileges.

The columns in user_col_privs_made:

Column	Type	Description
grantee	VARCHAR2(30)	User to whom the privilege was granted
table_name	VARCHAR2(30)	Name of the object on which the privilege was granted
column_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)

The following example queries user_col_privs_made:


SELECT * FROM user_col_privs_made;

Object Privileges: