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.

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.