[原]Oracle 11g的整人新特性——密码大小写敏感

时间:2022-09-10 00:48:47

      第一次使用 Oracle 11g 是冲着它的 interval 分区去的,当把应用迁过去之后发现登录不了,死活说密码错误,当时应急的做法是把密码改纯数字,今天有空好好地搜索了一下,才发现“密码大小写敏感”是 Oracle 11g 才引入的新特性,对应的参数是 sec_case_sensitive_logon ,看以下的实验过程:

sys@FWDB SQL> show parameter sec_case_sensitive_logon 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE
sys@FWDB SQL> alter user scott account unlock ; 

User altered.

Elapsed: 00:00:00.01
sys@FWDB SQL> alter user scott identified by tIger;

User altered.

Elapsed: 00:00:00.00
sys@FWDB SQL> connect scott/tiger  
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
sys@FWDB SQL> connect scott/tIger  
Connected.
scott@FWDB SQL> connect / as sysdba
Connected.
sys@FWDB SQL> alter system set sec_case_sensitive_logon=false;

System altered.

Elapsed: 00:00:00.01
sys@FWDB SQL> connect scott/tiger                              
Connected.
scott@FWDB SQL> connect scott/tIger                              
Connected.

      说真的,我不喜欢这个新特性。