Database Administration (MOSC)

MOSC Banner

Secure the SYS connection from Windows OS Authentication

edited May 7, 2012 2:16AM in Database Administration (MOSC) 3 commentsAnswered
Hello,

  I have a database Oracle 10g installed under Windows 2008 Server. As we know, starting 10g, the database can be authenticated by OS. This means,

when an Administrator OS log in, he can simply use : SQLPLUS SYS/anypassword as SYSDBA and he will be connected to the database. Even he can

use SQLPLUS anyname/anypassword as SYSDBA and he will be logged in.

This can be limited by setting the AUTHENTICATION to NONE instead of NTS in SQLNET.ORA at the database Server level.

But what if the System Administrator knows this SQLNET.ORA , so he can change it and log in again.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center