Information
This setting PASSWORD_ROLLOVER_TIME enables the gradual database password rollover time allowing both the new and old password to be used for a set period of time after a password is changed. This capability is not normally appropriate for human actors, but is frequently valuable for application and batch processing service accounts.
With the need to change passwords at some frequency and the goal to limit downtime for applications operating across multiple tiers it is necessary to have an overlap period where both the new and old passwords are accepted. This allows time for all tiers supporting the application to be updated to use the new password.
Solution
Remediate this setting by executing the following SQL statement for each PROFILE returned by the audit procedure.
ALTER PROFILE DEFAULT LIMIT PASSWORD_ROLLOVER_TIME 0;
Impact:
Configuring this setting could result in application account lockouts which may impact the service(s) provided by the application. To minimize the impact, you may set this setting to a sufficiently higher value for you to update applications and batch processes to use new passwords after a password change.