Database Administration (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center