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
/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

Sqlnet. Authentication_services= (NTS)
NAMES. Directory_path= (TNSNames)
[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.

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

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: info-contact@alibabacloud.com 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.