Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connect as sysdba on 9i

RE: Connect as sysdba on 9i

From: Babich , Sergey <SBabich_at_handexmail.com>
Date: Tue, 22 Jan 2002 08:08:52 -0800
Message-ID: <F001.003F7201.20020122073521@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US