Printable View
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:confused:
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.
Hi,
If you have access to metalink.oracle.com,please notice note 1015884.6
Regards,
Nir
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.
Can you post the output from you sql*plus session including:
The exact statement you are issuing
and
the exact error message being received.