DB Users are required to reset the password periodically for better security. For some service accounts, we need to make sure the password does not expire and does not impact the application.
For this purpose, we need to update that user’s Profile. Each Profile has multiple security settings that controls Password_life_time, password_reuse_time, password_reuse_max settings. These are settings that control the behavior of Password.
- PASSWORD_REUSE_TIME
The number of days passed before reusing the old password.
- PASSWORD_REUSE_MAX
The number of password changes before reusing the old password.
To make DB User password never expire:
alter profile default
limit
password_reuse_time unlimited
password_reuse_max unlimited
PASSWORD_LIFE_TIME UNLIMITED;