RE: connect / as sysdba on 9i

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 5 Feb 2004 11:02:03 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F602621033DAE89@irvmbxw02>

In Windows 2000 / Oracle 9.2, I am able to do the following: set ORACLE_SID=3Dinstance_name
sqlplus /nolog
connect / as sysdba

I logged on to the Windows 2000 database server as a user who is in the = ORA_DBA Windows group.

In my sqlnet.ora I have
SQLNET.AUTHENTICATION_SERVICES =3D (NTS) On the Windows 2000 / Oracle 9.2 system used in the above test, if I set = SQLNET.AUTHENTICATION_SERVICES =3D (NONE) in sqlnet.ora, then when I try connect / as sysdba
I see the message "Insufficient privileges."

> -----Original Message-----
> Mohammad Rafiq

>=20

> What about Windows 2000 when same behaviour while logging as=20
> sys(not system)as=20
> and user is a part of dba group. I think it depends on setting of=20
> remote_login_passwordfile=3DEXCLUSIVE( if setting is NONE no problem).

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 05 2004 - 13:02:03 CST