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.

Note: NTS means OS authenticated and NONE value means password file authenticated.

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. Used to connect with OS 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