Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to restrict sqlplus as sysdba

936666Apr 29 2013 — edited May 2 2013

how to restrict sqlplus as sysdba

C:>\ Set Oracle_sid=Mydb

C:>\sqlplus / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

I don't want to log in any one as sqlplus / as sysdba.
If they can able to login as sqlplus / as sysdba then they can see others schema in the database.

Say if i set

SQLNET.AUTHENTICATION_SERVICES=none

no one can log in as sysdba were as later some one changes to

SQLNET.AUTHENTICATION_SERVICES=NTS
After they changes to NTS they can log in and access other user details right ? how to restrict

Oracle version: Oracle 11 g
OS Version :Win 7

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2013

Added on Apr 29 2013

#general-database-discussions

21 comments

1,490 views