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

Thread: DBA privs - how to confirm?

  1. #1
    Join Date
    May 2008
    Posts
    29

    DBA privs - how to confirm?

    How do I know (which table?) whether an user has DBA privs in Oracle?

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    log on to the user and type

    select * from session_privs;
    select * from session_roles;

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    It is really amazing how some people are compeled to post half a%$%#s answers...

    1- session_privs query does not answers the poster's question
    2- who told you poster knows the affected user password?
    3- wouldn't be much simpler to do something like...
    Code:
    select  *
    from    dba_role_privs
    where   grantee      = 'AFFECTED_USERNAME'
        and granted_role = 'DBA'
    ;
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    You are correct PAVB

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Ah...why simplicity if complexity reigns.

    Quote Originally Posted by gopu_g
    You are correct PAVB
    1604 posts say PAVB is as close to correct as can get.

    A more elegant solution would be this one:
    Code:
    Select Grantee||' Has DBA Privileges!' "Watch out you bums"
      From Dba_Role_Privs Where Granted_Role='DBA';
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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