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

Source: Internet
Author: User

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
[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 Production on Sat 22 17:14:08 2014

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

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.