oralce 禁用操作系统登录

windows下默认oracle用户可以通过操作系统验证方式登录 即输入 conn /  as sysdba方式即可以登录oracle，这样是很不安全的，为了提高系统的可靠性，必须让用户输入密码才能登陆，怎么处理呢，可以修改sqlnet.ora这个文件 ，在里面添加 SQLNET.AUTHENTICATION_SERVICES这个变量，为变量赋值NONE，使用密码文件方式登录

即SQLNET.AUTHENTICATION_SERVICES= (NONE)

 

windows下sqlnet.ora文件的位置D:\oracle\network\admin

 

SQLNET.AUTHENTICATION_SERVICES参数含义

NONE - No special authentication is performed. Users log in using their usernames and passwords.
ALL - Enable all the authentication methods.
BEQ - Enable the BEQ authentication method.
CYBERSAFE - Allows users to be authenticated using CyberSafe.
DCEGSSAPI - Allows users to be authenticated using DCE GSSAPI.
IDENTIX - Allows users to be authenticated using Identix.
KERBEROS5 - Allows users to be authenticated using Kerberos.
NDS - Allows users to be authenticated using Netware Directory Services.
NTS - Allows users to be authenticated using Windows Native security.
RADIUS - Allows users to be authenticated using RADIUS.
SECURID - Allows users to be authenticated using SecureID.
TCPS - Allows users to be authenticated using SSL.