RE: Connect as sysdba on 9i

[Babich , Sergey]

Title: Connect as sysdba on 9i

That exactly connects you as SYS which u can check with SHOW USER

Just my $.02.

Regards,

Sergey Babich

-----Original Message-----
From: eric harrington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Connect as sysdba on 9i

Try:

sqlplus "/ as sysdba"

I suspect the / indicates current OS user and if you belong to the SYSDBA or SYSOPER groups then you will be connected.  SYS is probably not a member of these groups.

I haven't tested this.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, Helmut
Sent: Tuesday, January 22, 2002 7:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Connect as sysdba on 9i

Hi!

I have a question concerning "connect sys as sydba" on 9i.

When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user):

sqlplus "sys as sysdba"

Oracle asks for a password. Even if I type in the wrong password, I am connected to Oracle. So does Oracle just use the OS authentication (like connect internal did on 8i)?

But why is Oracle asking for a password in the first place then? Any ideas?

This is 9.0.1 on Sun Solaris.

Thanks,
Helmut