Hi DBAs,
Does anyone have a scipt to find out the various oracle roles and privileges for users in the database?
thanks in advence...
Printable View
Hi DBAs,
Does anyone have a scipt to find out the various oracle roles and privileges for users in the database?
thanks in advence...
you can look at dba_role_privs, user_role_privs, user_sys_privs
Thnx...i've looked @ the above listed dd tables, but just thought s'one has a custom script that joins the various tables to produce a single report...