I have created a profile with PASSWORD_VERIFY_FUNCTION ora12c_strong_verify_function .But while creating user and assigning the profile ,I am not able to change the password with any special character other than $ .So I need to know how can I modify the ora12c_strong_verify_function function so that I can use other special character.
This is the function .
CREATE OR REPLACE NONEDITIONABLE FUNCTION "SYS"."ORA12C_STRONG_VERIFY_FUNCTION
"
(username varchar2,
password varchar2,
old_password varchar2)
return boolean IS
differ integer;
begin
if not ora_complexity_check(password, chars => 9, upper => 2, lower => 2,
digit => 2, special => 2) then
return(false);
end if;
-- Check if the password differs from the previous password by at least
-- 4 characters
if old_password is not null then
differ := ora_string_distance(old_password, password);
if differ < 4 then
raise_application_error(-20032, 'Password should differ from previous '
|| 'password by at least 4 characters');
end if;
end if;
return(true);
end;