How to block Oracle's operating system authentication on different operating systems

On the Windows system > If you do not want the user through the operating system authentication mode login, you can modify the Sqlnet.ora file, put sqlnet. Authentication_services=nts the front plus # comment out.

On Linux Systems > If you do not want users to log on by operating system authentication, you can create a Sqlnet.ora file, plus
Sqlnet. The authentication_services is set to None or NTS, which are screened for operating system authentication based on Oracle password authentication.

Linux under Demonstration:

[Email protected] admin]$ pwd
/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin
[email protected] admin]$ Touch Sqlnet.ora
[email protected] admin]$ LL
Total 24
-rw-r--r--. 1 Oracle Oinstall 22 16:58 1
-rw-r--r--. 1 Oracle Oinstall 315 OCT 9 17:50 Listener.ora
Drwxr-xr-x. 2 Oracle Oinstall 4096 Nov 16:46 samples
-rw-r--r--. 1 Oracle Oinstall 187 May 8 Shrept.lst
-rw-r--r--. 1 Oracle Oinstall 17:11 Sqlnet.ora
-rw-r-----. 1 Oracle Oinstall 18:02 Oct 9 Tnsnames.ora
[email protected] admin]$ cat Sqlnet.ora

NAMES. Directory_path= (Tnsnames,ezconnect)
Sqlnet. Authentication_services= (NONE)

[Email protected] admin]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.1.0 Production on Sat 22 17:14:08 2014

Copyright (c) 1982, Oracle. All rights reserved.

ERROR:
Ora-01031:insufficient Privileges

OK, success. Reprint please indicate the source.

Copyright NOTICE: This article is for bloggers original articles, can be reproduced, but must be linked to the form of the Declaration of origin. 53845009Personal Category: Oracle architectureWant to say something to the author? I'd say a come from:53845009.

How to block Oracle's operating system authentication on different operating systems