oracle 修改密码大小写,oracle 设置密码不分大小写

Database Administrators can authenticate database administrators through the data

dictionary, (using an account password) like other users. Keep in mind that beginning

with Oracle Database 11g Release 1, database passwords are case-sensitive. (You can

disable case sensitivity and return to pre–Release 11g behavior by setting the SEC_

CASE_SENSITIVE_LOGON initialization parameter to FALSE.)

oracle从11g开始，默认情况下，密码是有大小写区分的，但是可能通过SEC_CASE_SENSITIVE_LOGON

参数设置 ，当该参数设置为false时密码不区分大小写

SQL> show parameter sec_case_sensitive_logon

NAME TYPE VALUE

sec_case_sensitive_logon boolean TRUE

默认情况下该参数的值为true

SQL> alter system set sec_case_sensitive_logon=false scope=both;

System altered.

SQL> conn scott/ORACLE

Connected.

SQL>

修改参数后，可以用大写密码来登陆账号(原来密码是oracle)