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

Thread: granting sysdba privilege

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    granting sysdba privilege

    hi
    i get an error when i grant sysdba priviliege to any user for .eg. scott. it says user or role does not exist. this error is not through the oem but through sqlplus. it grants sysdba privilege through oem but when i query v$pwfile_users it only shows sys, internal having sysdba privileges and not for scott.
    what could be the problem.
    thanks

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    How many entries did you define for your password file?

    Are you connect as a sysdba user when you issue the command?

    "user or role does not exist" what is the exact command you are issuing and can you confirm the user does exist.
    Last edited by jovery; 05-01-2003 at 05:44 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi,

    If you have access to metalink.oracle.com,please notice note 1015884.6

    Regards,
    Nir

  4. #4
    Join Date
    Apr 2003
    Posts
    46
    hi Nir i don't have access to metalink. thanks anyway.

    Jovery , i have defined 2 entries in the password file.
    the command was
    grant sysdba to scott
    i connected with sys account as sysdba
    the user scott does exist , and and i can even connect to this user from sqlplus.
    thanks.

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Can you post the output from you sql*plus session including:

    The exact statement you are issuing
    and
    the exact error message being received.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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