Friday, August 29, 2014

ORACLE: How do I set up passwords to NEVER expire?


Run the below query to set up SYSTEM password never expire

SQL> select profile from dba_users where username = 'SYSTEM';
PROFILE
--------------------------
DEFAULT

SQL> alter profile DEFAULT limit password_life_time unlimited;

Profile altered.


After doing this...Reset the password of the user again.

SQL> alter user SYSTEM identified by new-password;

User altered.

By doing this,the password will never expire.

No comments: