Oracle 12C R2-废弃功能-密码验证函数(VERIFY_FUNCTION 和VERIFY_FUNCTION_11G)

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函数验证密码必须满足以下要求：

1. The password contains no fewer than 8 characters and includes at least one numeric and one alphabetic character.

2. The password is not the same as the user name or the user name reversed.

3. The password is not the same as the database name.

4. The password does not contain the word oracle (such as oracle123).

5. The password differs from the previous password by at least 8 characters.

6. The password contains at least 1 special character.

7. The following internal checks are also applied:

8. The password does not exceed 30 characters.

9. The password does not contain the double-quotation character ("). However, it can be surrounded by double-quotation marks.

ora12c_strong_verify_function函数验证密码必须满足以下要求：

1. 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)

2. The password must differ from the previous password by at least 4 characters.

内部检查:

1. The password contains no fewer than nine characters and does not exceed 30 characters.

2. The password does not contain the double-quotation character ("). It can be surrounded by double-quotation marks, however.