Setting Oracle Database User Password Not to Expire

Here are the steps to set the password not to expire for the Oracle database user. Here we are assuming that the user has been assigned with the default profile:

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL> alter user scott identified by tiger;

User altered.

Caution: This is not recommended for production environment. You should check with corporate security policy before altering any profile changes related to passwords.