Password change minimum age
Hi team,
In our 12.1.0.2 database we have setup new password profile for new database accounts where user cannot change password more than once during a day.
I have enforced that by using adding password verify function to the database profile. Function looks like this:
CREATE OR REPLACE function SYS.ora12c_strong_verify_24h
(username varchar2,
password varchar2,
old_password varchar2)
return boolean IS
differ integer;
last_change sys.user$.ptime%type;
minimum_age number :=1;
begin
if not ora_complexity_check(password, chars => 8, upper => 1, lower => 1,
digit => 1, special => 1) then
return(false);
end if;
-- Check if the password differs from the previous password by at least