SQLNET.AUTHENTICATION_SERVICES
To enable one or more authentication services. If authentication has been installed, then it is recommended that this parameter be set to eithernone
or to one of the authentication methods.
None
Note:
When installing the database with Database Configuration Assistant (DBCA), this parameter may be set tonts
in thesqlnet.ora
file.
-
Authentication Methods Available with Oracle Net Services:
-
none
for no authentication methods, including Microsoft Windows native operating system authentication. WhenSQLNET.AUTHENTICATION_SERVICES
is set tonone
, a valid user name and password can be used to access the database. -
all
for all authentication methods. -
nts
for Microsoft Windows native operating system authentication.
-
-
Authentication Methods Available with Oracle Advanced Security:
-
kerberos5
for Kerberos authentication. -
radius
for RADIUS authentication. -
tcps
for SSL authentication.
-
SQLNET.AUTHENTICATION_SERVICES=(kerberos5)
此时是操作系统验证和Oracle密码验证并存,加上SQLNET.AUTHENTICATION_SERVICES这个参
数后,不管SQLNET.AUTHENTICATION_SERVICES设置为NONE还是NTS还是(NONE,NTS),都是
基于Oracle密码验证。