How to Stop Account Password Expired Notice in Oracle

  • by

Make sure that you're in the right database.

SQL> select name from v$database;

NAME
---------------------------
ORCL

Check what profile the user is applied.

SQL> select profile from dba_users where username = 'STEVE';

PROFILE
--------------------------------------------------------------------------------
DEFAULT

We set unlimited PASSWORD_LIFE_TIME on profile DEFAULT.

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

Leave a Reply

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