Run the below query to set up SYSTEM password never expire
SQL> select profile from dba_users where username = 'SYSTEM';
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:
Post a Comment