I have been working in Sql developer for certain time, few days back found new notification/warning windows is popping up with the error message - ORA-28002: the password will expire within 6 days (certain string) as below :
Although there are many other ways you can get rid of this notification/warning like changing the user password. But I'll prefer to set this value as unlimited instead changing the Password again in few weeks later.
Cause : Basically this is causing because Sql developer password expiration has been set to 180 days By default.
How to see Expiration: To view the validity of the password you can use below query:
select resource_name,limit from dba_profiles where profile='DEFAULT';
Output:
Now most of us will wonder can we change this date to unlimited, the answer is yes, we can by using below query:
Alter Profile Default Limit Password_Life_Time Unlimited;
Output: Profile DEFAULT Altered.
To check if the Password has been reset successfully, execute below query and verify the result.
select resource_name,limit from dba_profiles where profile='DEFAULT';
Final Note : You need to change the password again for new limit to take effect.
Thanks for reading this post.
