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.
Received on Wed Dec 20 2006 - 08:41:30 CST
