How do I find out what priviliges a particular user has? I need to create a new user and wanted to see what priviliges existing users have. I don't seem to find a link between dba_users and dba_roles or dba_users and any other tables that may possibly have priviliges listed.
Mary, you can always find a view or table by running the following queries:
select object_name from dba_objects where object_name like '%PRIV%';
That will give you for your questions. I suggest DBA_ROLE_PRIVS.
Also there is another query:
select name from v$fixed_table where name like '%PRIV%';
Quite interesting views you will get back. :-)
Alla S. Pfauntsch
"Life is what happens while you are planning something else".
query DBA_SYS_PRIVS and DBA_TAB_PRIVS
Query DBA_ROLE_PRIVS for roles, DBA_SYS_PRIVS for system privileges and DBA_TAB_PRIVS for object privileges.
Click Here to Expand Forum to Full Width