Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connect as sysdba on 9i
That
exactly connects you as SYS which u can check with SHOW USER
Just
my $.02.
<FONT face=Arial color=#0000ff
size=2>Regards,
Sergey
Babich
<FONT face=Tahoma
size=2>-----Original Message-----From: eric harrington
[mailto:eharrington_at_ecora.com]Sent: Tuesday, January 22, 2002 8:45
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Connect as sysdba on 9i
Try: <FONT
color=#000000 size=2>
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.
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of Daiminger,
HelmutSent: Tuesday, January 22, 2002 7:05 AMTo:
Multiple recipients of list ORACLE-LSubject: 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
Received on Tue Jan 22 2002 - 10:08:52 CST
![]() |
![]() |