AUTHENTICATION SERVICES Parameter in SQLNET file of Oracle

AUTHENTICATION_SERVICES Parameter in SQLNET file of Oracle

Authentication Service parameter is used to list the authentication method of connectivity with oracle database.

SQLNET.AUTHENTICATION_SERVICES value all the server attempts to authenticate using each of the following methods.

Authentication Method available in Oracle:
NONE for no authentication method. When parameter is set to none, a valid user name and password can be used to access the database.
ALL for all authentication methods. Default value is all.
BEQ for native operating system authentication for operating systems other than Microsoft Windows
KERBEROS5 for Kerberos authentication
NTS for Microsoft Windows native operating system authentication
RADIUS for Remote Authentication Dial-In User Service (RADIUS) authentication
TCPS for SSL authentication

DEFAULT VALUE

SQLNET.AUTHENTICATION_SERVICES = ALL

Example of windows Server

1. Value for SQLNET.AUTHENTICATION_SERVICES is NTS.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

2. Try to connect with SQLPLUS with OS User then its connected.

C:\Users\e3019447>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 12 14:26:38 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL>

3. Change the value of parameter to NONE.

SQLNET.AUTHENTICATION_SERVICES = (NONE)

4. It will give the permission error while tried to connect again with OS user.

C:\Users\e3019447>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 12 14:26:58 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.