【翻譯自mos文章】當sec_case_sensitive_logon = true後,怎麼啟用大小寫混合的密碼?,sensitive

來源:互聯網
上載者:User

【翻譯自mos文章】當sec_case_sensitive_logon = true後,怎麼啟用大小寫混合的密碼?,sensitive

當sec_case_sensitive_logon = true後,怎麼啟用大小寫混合的密碼?

來源於:
How To Enforce Mixed Case Passwords When sec_case_sensitive_logon = true? (文檔 ID 1307555.1)

適用於:
Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 20-SEP-2012***

目標:
在設定 sec_case_sensitive_logon = true之後,怎麼為database中的user啟用大小寫混合的密碼

解決方案:
The supplied password verify function in the file $ORACLE_HOME/rdbms/admin/utlpwdmg.sql  does not  enforce that the password has both upper and lower case characters. To achieve this, it is possible to modify the function as follows:

 cp utlpwdmg.sql utlpwdmg_modif.sql
 vi utlpwdmg_modif.sql

 Add the following code:

-- Check the password uses mixed caseif upper(password) = password or lower(password) = password thenraise_application_error(-20012, 'Password is not mixed case');end if;

Then run the script utlpwdmg_modif.sql as user SYS and to test:

create profile test_profile limit password_verify_function verify_function_11g; create user test identified by test profile test_profile; connect test/test SQL> alter user test identified by "kachel1#" replace test; alter user test identified by "kachel1#" replace test * ERROR at line 1: ORA-28003: password verification for the specified password failed ORA-20012: Password is not mixed case SQL> alter user test identified by "KACHEL1#" replace test; alter user test identified by "KACHEL1#" replace test * ERROR at line 1: ORA-28003: password verification for the specified password failed ORA-20012: Password is not mixed case SQL> alter user test identified by "Kachel1#" replace test; User altered.

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.