Thursday, May 20, 2010

HOW to prevent login as a "SYSDBA" oracle

1) First step is to find file : "SQLNET.ora" and you can find this here :
[ORACLE_HOME]\NETWORK\ADMIN

2) Find Statement : SQLNET.AUTHENTICATION_SERVICES= (NTS)

3) Remove NTS parameter from above statement

4) Thats It! Now try to login as "/ as sysdba" or "username/password as sysdba"

5) NONE WILL WORK OUT ! Thats what you wann!

Thank yOu

I love Oracle !

No comments:

Post a Comment