user priviliges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: user priviliges

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    Hi all,
    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.
    Thank you.

  2. #2
    Join Date
    Sep 2000
    Posts
    43
    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

    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

  3. #3
    Join Date
    Oct 2000
    Posts
    23
    query DBA_SYS_PRIVS and DBA_TAB_PRIVS

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    Query DBA_ROLE_PRIVS for roles, DBA_SYS_PRIVS for system privileges and DBA_TAB_PRIVS for object privileges.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width