Knowledge Base Change the User's password Life Time

When Changing the users password Lifetime.this can be done with the profile alteration. Else you need to create a new profile only for that particular user.

This is done with the changing user profile values.

 

Check the relevant profile for the particular user.

Select profile from DBA_USERS where username = 'SYS';

You can alter the profile for the relevant user.

Normally default  profile name is DEFAULT.

If profile name is DEFAULT you can change it to unlimited or give numbers of days of the password life time

Alter profile DEFAULT limit password_life_time UNLIMITED;

Or mention the number of days

Alter profile DEFAULT limit password_life_time 200;