Scenario:
Trying to reset to the existing password throws following error.
ERROR at line 1:
ORA-28007: the password cannot be reused
Solution:
Check the user profile set for the user. Check for the existence of a password verify function in the profile.
Set the password_verify_function to NULL
Another reason could be that the PASSWORD_REUSE_MAX limit has reached. If so set to a higher value or to UNLIMITED and reset the password as shown below.
SQL> alter profile default limit PASSWORD_REUSE_MAX unlimited;
SQL> alter user USERNAME identified by <PREV_PWD>;
Trying to reset to the existing password throws following error.
ERROR at line 1:
ORA-28007: the password cannot be reused
Solution:
Check the user profile set for the user. Check for the existence of a password verify function in the profile.
Set the password_verify_function to NULL
Another reason could be that the PASSWORD_REUSE_MAX limit has reached. If so set to a higher value or to UNLIMITED and reset the password as shown below.
SQL> alter profile default limit PASSWORD_REUSE_MAX unlimited;
SQL> alter user USERNAME identified by <PREV_PWD>;
No comments:
Post a Comment