1 说明
The VERIFY_FUNCTION and VERIFY_FUNCTION_11G password verify functions have been deprecated for this release.
These functions are deprecated because they enforce the weaker password restrictions from earlier releases. Instead, you should use the ORA12C_VERIFY_FUNCTION and ORA12C_STRONG_VERIFY_FUNCTION functions, which enforce stronger, more up-to-date password verification restrictions.
从12.2开始，之前两个VERIFY_FUNCTION 和VERIFY_FUNCTION_11G密码验证函数将不再被使用。由ORA12C_VERIFY_FUNCTION 和ORA12C_STRONG_VERIFY_FUNCTION 两个函数来代替，从而提高密码的安全复杂性。
ora12c_verify_function函数验证密码必须满足以下要求：
- The password contains no fewer than 8 characters and includes at least one numeric and one alphabetic character.
- The password is not the same as the user name or the user name reversed.
- The password is not the same as the database name.
- The password does not contain the word oracle (such as oracle123).
- The password differs from the previous password by at least 8 characters.
- The password contains at least 1 special character.
- The following internal checks are also applied:
- The password does not exceed 30 characters.
- The password does not contain the double-quotation character ("). However, it can be surrounded by double-quotation marks.
ora12c_strong_verify_function函数验证密码必须满足以下要求：
- The password must contain at least 2 upper case characters, 2 lower case characters, 2 numeric characters, and 2 special characters. These special characters are as follows:
‘ ~ ! @ # $ % ^ & * ( ) _ - + = { } [ ] / / < > , . ; ? ’ : | (space) - The password must differ from the previous password by at least 4 characters.
内部检查:
- The password contains no fewer than nine characters and does not exceed 30 characters.
- The password does not contain the double-quotation character ("). It can be surrounded by double-quotation marks, however.
