Ok, this is a common issue, once it’s like the default behavior of oracle for DEFAULTĀ profile, used as DEFAULT to new users. But it’s really easy to solve. š
Before expiring you should be received some:
ORA-28002: the password will expire within x days
Ok then, but what if you are facing errors to reuse the same password, don’t know the password and yet, how to never let it happen again?
An unexpected error, right?
SQL> CREATE PROFILE TEST_PROF LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LIFE_TIME 180 PASSWORD_GRACE_TIME 30 PASSWORD_REUSE_MAX 15 PASSWORD_VERIFY_FUNCTION fnc_validation; CREATE PROFILE TEST_PROF LIMIT * ERROR at line 1: ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION FNC_VALIDATION
That is a simple need. You have to use 3 parameters on function: username varchar2, password varchar2, old_password varchar2.
Matheus.
