Starting with this release, an application can change its database passwords without an administrator having to schedule downtime.
To accomplish this, a database administrator can associate a profile having a non-zero limit for the
PASSWORD_ROLLOVER_TIME password profile parameter, new with this release, with an application schema. This allows the database password of the application user to be altered while allowing the older password to remain valid for the time specified by the
PASSWORD_ROLLOVER_TIME limit. During the rollover period of time, the application instance can use either the old password or the new password to connect to the database server. When the rollover time expires, only the new password is allowed.
Before this enhancement, an administrator normally took the application down when the application database password was being rotated. This is because the password update requires changes on both the database and the application side. With the gradual database password rollover enhancement, the application can continue to use the older password until the new password is configured in the application.
In addition to the new clause
PASSWORD_ROLLOVER_TIME in the
CREATE PROFILE and
ALTER PROFILE statements, the
ALTER USER statement has a new clause,
EXPIRE PASSWORD ROLLOVER PERIOD. The
ACCOUNT_STATUS column of the
USER_USERS data dictionary views have several new statuses indicating values to indicate rollover status.