Database Administration (MOSC)

MOSC Banner

Users, roles, privelages

edited Jan 7, 2016 2:33PM in Database Administration (MOSC) 9 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center