DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: User Query

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    User Query

    Hi Everyone,

    Can anyone tell me how to query the roles and system privileges of the individual (or all) schemas in an Oracle database instance?

    I know I could look through the manuals, but I'm short on time at the moment.

    Thanks
    Peer
    Last edited by Peer Jones; 06-17-2004 at 01:57 AM.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    DBA_SYS_PRIVS
    DBA_ROLE_PRIVS
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    Thanks for the help, just what I was looking for.
    Sorry about the late reply, but I got distracted.
    Bye
    Peer

  4. #4
    Join Date
    Nov 2001
    Posts
    118
    Aargh! I just noticed that there's something missing.

    I was also hoping for a query or the data dictionary views that also show me the object priviledges granted from one schema to another.

    Sorry I was unclear about that.

    Bye
    Peer

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    DBA_TAB_PRIVS
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Nov 2001
    Posts
    118
    Big smiles!
    Thank you.

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