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.
The number of days passed before reusing the old password.
The number of password changes before reusing the old password.
To make DB User password never expire:
alter profile default