Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Location
    US-AZ
    Posts
    9

    Unanswered: need script to locate dba roles

    Looking for a script to ID all schemas/users assigned DBA role privs on 9i DB
    Last edited by irishmc; 10-14-04 at 17:24.

  2. #2
    Join Date
    Apr 2004
    Posts
    246
    select grantee from dba_role_privs where granted_role='DBA'

    of course, if you granted DBA to a role, and then granted that role to a user, you'll need to make the query recursive: where granted_role = ( select grantee... )
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Oct 2004
    Location
    US-AZ
    Posts
    9
    The later is true.....
    Thanks for the help!!

Posting Permissions

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