Find in this Blog

Thursday, May 16, 2019

Oracle Password Expire set unlimited

I am getting password expire each 4 5 months, I wan to set to unlimited


SQL> connect sqlplus"/as sysdba"


SQL> alter user system account unlock ;




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


Thanks
Yoonus

No comments:

Post a Comment

Ask Your Questions ?#