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.