How come password_reuse_max is not enforced?
Hi I have created a profile and a user userabc with that profile
CREATE PROFILE new_profile LIMIT PASSWORD_REUSE_MAX 3 PASSWORD_REUSE_TIME 10;
when I change the password to "password12345" and change the password again back to "password1234", I'm excepting the password change to be rejected since PASSWORD_REUSE_MAX is set to 3. I shouldn't be able to use back the old password.
I changed the password with the following command
ALTER USER userabc IDENTIFIED BY 'password12345' REPLACE 'password1234'; ALTER USER userabc IDENTIFIED BY 'password1234' REPLACE 'password12345';
Did I miss out some setting?
Thanks a lot for your help vertica community.