Hi all,
11.2.0.3.11
aix6
Everytime I set our profile with the password limits, our app gets error or aborted or failed, once the profile password setting displays warning that password will expire it 7 days.
How do I avoid this please...
How do I prevent this warning 7 days to happen? For example I have this ONLINE_PROFILE:
ALTER PROFILE ONLINE_PROFILE LIMIT
PASSWORD_LIFE_TIME 90
PASSWORD_GRACE_TIME 7
PASSWORD_REUSE_TIME 365
PASSWORD_REUSE_MAX 20
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 1
PASSWORD_VERIFY_FUNCTION verify_function_11G;
Since it it will expire 90 days, so at 84th day (7 day grace time) it will prompt the warning message.
Supposing I have a cron schedule such that at 80th day I will force change the password using a scheduled script, will it resolve the issue?
Thanks,
mk