Re: URGENT: Strange Problem... Please help...

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 6 Sep 2005 12:41:02 +0200
Message-ID: <01d901c5b2cf$847c4c00$1a03310a@IBME1D11967173>

With "/ as sysdba" you get authenticated by the OS, no metter what user/pass you're giving:

SQL> conn nouser/nopass as sysdba
Connected.
SQL> sho user
USER is "SYS"
SQL> select username from dba_users where username='NOUSER';

no rows selected

SQL> Regards,
Dimitre Radoulov

Original Message ----- From: DBA Deepak To: oracle-l_at_freelists.org Sent: Tuesday, September 06, 2005 12:34 PM Subject: URGENT: Strange Problem... Please help...

Hi Gurus,

I used the following set of commands on my DB server.

C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Sep 6 15:25:27 2005

  SQL> conn sys/change_on_install as sysdba   Connected.
  SQL> conn sys/change_on_install123 as sysdba   Connected.
  SQL> conn sys/change_on_install123456789 as sysdba   Connected.
  SQL> conn sys/change_on_inasdastall123456789 as sysdba   Connected.
  SQL>   I would like to know why does Oracle allow me to connect using any random   passowrd for SYS user?

We have remote_login_passwordfile=EXCLUSIVE set in the pfile.

Please help me...

--
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 06 2005 - 05:43:12 CDT