Users, roles, privelages
Oracle DB: 11.2.0.4
OS: Linux
I am looking to produce a report for many Oracle Users similar to following two users. This will include all roles granted on all production schema( i.e. prod1_select_role, prod1_dml_role, etc.), grants on dictionary views, select or DML grants on any individual tables on other schema.tables, and any proxy user grants.
Example queries are appreciated. thanks you.
JSMITH
Prod1_select_role
Prod1_DML_role
Prod2_select_role
Prod2_DML_role
select on prod3.emp_salary
select on Prod3.emp_address
Insert,update,delete on Prod3.emp_info
insert, update on Prod4.HR