PASSWORD_ROLLOVER_TIME
Greetings,
We're running 19c EE and attempting to use PASSWORD_ROLLOVER_TIME as a safeguard method for online application password resets.
One behavior we're noticing is that with an extended setting for that (ex. 30 days), if a password is reset more than once prior to the rollover end date, not only does PASSWORD_CHANGE_DATE within dba_users not get updated, but as well the previous password (not the original) is no longer valid. Is this expected behavior? Also is there anyway to tell if a password reset has been issued (aside from something like auditing) for an account when that account status is 'OPEN & IN ROLLOVER'?