Tuesday, August 3, 2010

Preventing SYSDBA login



Normally SYS logs in as

sqlplus “/ as sysdba”

SQLNET.AUTHENTICATION_SERVICES=(NTS)
• Change SQLNET.ORA file:

SQLNET.AUTHENTICATION_SERVICES=(NONE)

• now SYS has to provide the password

sqlplus sys/ as sysdba