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 ;
SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
SQL> select username, account_status, EXPIRY_DATE from dba_users where username='BURLESON';
USERNAME ACCOUNT_STATUS EXPIRY_DATE
------------------------------ ---------------------------- ---------
BACMONIT OPEN 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 ?#