Re: SYS account with two passwords

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in news:999120046.24322.0.nnrp-02.9e984b29_at_news.demon.co.uk:

>
> Here's a cute little addition with Oracle 9.
>
> It looks as if SYS cannot log in as a normal user,
> only as a sysdba.

While logged onto Solaris as user oracle. Needless to say, this instance does has OS_AUTHENTICATION enabled. I have always thought that the use of the "/" implied OS_AUTH. I acknowledge that by using it I'm not really SYS, but I did get logged in by using just the "/".

<oracle_at_pandora:/u01/home/oracle:350> sqlplus

SQL*Plus: Release 9.0.1.0.0 - Production on Wed Aug 29 17:38:40 2001

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Enter user-name: /

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option
JServer Release 9.0.1.0.0 - Production

SQL> sho user
USER is "OPS$ORACLE"
SQL> connect / as sysdba
Connected.
SQL> sho user
USER is "SYS"
SQL> HTH & YMMV Received on Wed Aug 29 2001 - 19:37:35 CDT