Re: Question regardin password file

Mangood a écrit :
Hi
I have strange problem with password file. I'm using oracle 9.2 I have
remote_login_password set to exclusive. I tried to grant dba to
antother user. Oracle didn't show any error (moreover I got grant
succeded) but when I check v$pwdfile_users user is not listed there.
Also I cannot connect as sysdba using this user. What is more strange
when I log using user credentials I can select data from any dba tables
(e.g dba_users and so on). I cannot find any solution. Please help
Thanks in advance.


Hi, you granted the 'DBA' role, but you wanted to grant the 'SYSDBA' privilege: GRANT SYSDBA TO user
Then you will be able to log as sysdba (you will then be SYS) and you will see it in v$pwdfile_users
Regards,
Franck.


--
Franck PACHOT - Oracle Certified DBA - France, Sophia-Antipolis.
.