[原]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.
說真的,我不喜歡這個新特性。
浙公網(wǎng)安備 33010602011771號