How To Keep Same Password For Oracle User When Its EXPIRED(GRACE) State

unlock کردن یوزر EXPIRED بدون تغییر رمز عبور آن.

 

Users’ passwords are valid for the duration of PASSWORD_LIFE_TIME in their profile. At the end of this period the password expires and must be changed. After the password expires, the user’s status will be in EXPIRED(GRACE) State until the day of PASSWORD_GRACE_TIME in the profile.

Detailed information about Oracle profiles can be found in the following article.

 

 

You can create the necessary command with the following query to change user status from EXPIRED (GRACE) to NORMAL by keeping the current password.