-
user roles and privileges
Hi DBAs,
Does anyone have a scipt to find out the various oracle roles and privileges for users in the database?
thanks in advence...
Regards,
divroro12
-
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...
Regards,
divroro12
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|