problem with OS authentication
My domain user is member of ORA_DBA group on a remote machine. When I use the remote desktop connectivity and log on to the SQLPLUS, then my connection as sysdba fails as follows:
SQL> conn sys@orac as sysdba
ORA-01031: insufficient privileges
I have never encountered it before. Have I missed out anything that I am not able to recall? I know it's simple. But I am not able to correct it. As a workaround, I am able to use password file authentication by supplying password. But being a member of ora_dba, I should need to supply my password. It's a Windows box 2003 Server with Oracle 10g R2.
Click Here to Expand Forum to Full Width