Creating a Custom Password Function

Create a Custom Password Function - Example

begin
    rdsadmin.rdsadmin_password_verify.create_verify_function(
        p_verify_function_name => 'MyPasswordFunction', 
        p_min_length           => 15, 
        p_min_uppercase        => 1, 
        p_min_digits           => 2, 
        p_min_special          => 1,
        p_disallow_at_sign     => true);
end;
/

Valid Parameters

Parameter Name Data Type Default Required Description
p_verify_function_name varchar2 n/a Required The name for your custom function. This function is created for you in the SYS schema. You assign this function to user profiles.
p_min_length number 8 Optional The minimum number of characters required.
p_max_length number 256 Optional The maximum number of characters allowed.
p_min_letters number 1 Optional The minimum number of letters required.
p_min_uppercase number 0 Optional The minimum number of uppercase letters required.
p_min_lowercase number 0 Optional The minimum number of lowercase letters required.
p_min_digits number 1 Optional The minimum number of digits required.
p_min_special number 0 Optional The minimum number of special characters required.
p_min_different_chars number 3 Optional The minimum number of different characters required between the old and new password.
p_disallow_username boolean true Optional Set to true to disallow the username in the password.
p_disallow_reverse boolean true Optional Set to true to disallow the reverse of the username in the password.
p_disallow_db_name boolean true Optional Set to true to disallow the database or server name in the password.
p_disallow_simple_strings boolean true Optional Set to true to disallow simple strings as the password.
p_disallow_whitespace boolean false Optional Set to true to disallow white space characters in the password.
p_disallow_at_sign boolean false Optional Set to true to disallow the @ character in the password.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License