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.
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.