Hi All,
A strange thing I have noticed with SYS user since Oracle 9i(never worked on earlier versions) is that I can connect to the SYS user as SYSDBA with wrong password as well! Please guide how to prevent this...
(I have searched for a solution online but was unable to find any :( )
SQL> CONN SYS/AAA@TEST AS SYSDBA
Connected.
SQL> DISC
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> CONN SYS/BBB@TEST AS SYSDBA
Connected.
SQL>
SQL> DISC
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
*009*