Skip to Content

Make Oracle password never expire

Last modified by Александр Таболин on 2023/12/04 19:06

Информационные материалы проекта UNA » Регламенты Unisim-Soft » IT» Установка Oracle XE для сервера касс

Make Oracle password never expire
Oracle Database Tips by Donald BurlesonAugust 20, 2015
Question:  I am getting a password expired problem.  I want to fix this user ID such that the user ID never expires the password.  I want to keep my password and set Oracle to never expire my password.

How do I make a password non-expiring?

Solution for making a password never expire:

SQL> connect sys/secret_password as sysdba;

SQL> alter user sysman account unlock ;

SQL> alter user DBUSER identified by newpa$$word;

See these important notes in you want to changing_your_password.

Next, change the profile limit to unlimited.

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

Check the password expiry date 

SQL> select username, account_status, EXPIRY_DATE from dba_users where username='BURLESON';

USERNAME                       ACCOUNT_STATUS               EXPIRY_DATE

  

BACMONIT                       OPEN                         UNLIMITED