Checking Object Privileges Granted to a Role

role_tab_privs has object privileges have been granted to a role. The columns in role_tab_privs:

Column	Type	Description
role	VARCHAR2(30)	User to whom the privilege was granted
owner	VARCHAR2(30)	User who owns the object
table_name	VARCHAR2(30)	Name of the object on which the privilege was granted
column_name	VARCHAR2(30)	Name of the column (if applicable)
privilege	VARCHAR2(40)	Privilege on the object
grantable	VARCHAR2(3)	Whether the privilege was granted with the GRANT option (YES or NO)


SELECT * FROM role_tab_privs WHERE role='ROLE_NAME' ORDER BY table_name;

Roles: