Return
-
Title
TOAD and Oracle expired passwords -
Description
Oracle users are usually required to change their Oracle password every X number of days, sometimes with a Y number of days grace period. This method causes their account to be locked if they do not change their password after the grace period.
-
Cause
Profile with the following SQL code:
PASSWORD_GRACE_TIME 30 PASSWORD_LIFE_TIME 90 -
Resolution
Rewrite the code to expire the password after the grace period instead of locking it so that Oracle automatically generates a dialogue box prompting the user to change his password.