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

      第一次使用 Oracle 11g 是沖著它的 interval 分區(qū)去的，當(dāng)把應(yīng)用遷過去之后發(fā)現(xiàn)登錄不了，死活說密碼錯誤，當(dāng)時應(yīng)急的做法是把密碼改純數(shù)字，今天有空好好地搜索了一下，才發(fā)現(xiàn)“密碼大小寫敏感”是 Oracle 11g 才引入的新特性，對應(yīng)的參數(shù)是 sec_case_sensitive_logon ，看以下的實(shí)驗(yàn)過程：

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.

      說真的，我不喜歡這個新特性。