说明

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 and VERIFY_FUNCTION_11G密码验证函数将不再被使用。由ORA12C_VERIFY_FUNCTION and ORA12C_STRONG_VERIFY_FUNCTION 两个函数来代替,从而提高密码的安全复杂性。

关于两个函数具体复杂性要求:
ora12c_verify_function Password Requirements

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 Function Password Requirements:

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.

The following internal checks are also applied:

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.