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.

Leave a Reply

Your email address will not be published. Required fields are marked *