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.