PASSWORD_REUSE_MAX
873374Jul 25 2011 — edited Jul 25 2011Hello everyone,
From what I understand, PASSWORD_REUSE_MAX is the parameter which let me specify the number of password changes required before the current password can be reused.
Now, I did a very simple test :
SYS@orcl> ALTER PROFILE "DEFAULT" LIMIT PASSWORD_REUSE_MAX 4 ;
Profile altered.
SYS@orcl> -- (Rest of Default profile parameters are set to UNLIMITED)
SYS@orcl> CREATE USER pwd_test IDENTIFIED BY pwd_test1 ;
User created.
SYS@orcl> ALTER USER pwd_test IDENTIFIED BY pwd_test2 ;
User altered.
SYS@orcl> ALTER USER pwd_test IDENTIFIED BY pwd_test3 ;
User altered.
SYS@orcl> ALTER USER pwd_test IDENTIFIED BY pwd_test4 ;
User altered.
SYS@orcl> ALTER USER pwd_test IDENTIFIED BY pwd_test5 ;
User altered.
SYS@orcl> ALTER USER pwd_test IDENTIFIED BY pwd_test6 ;
User altered.
SYS@orcl> ALTER USER pwd_test IDENTIFIED BY pwd_test1 ;
ALTER USER pwd_test IDENTIFIED BY pwd_test1
*
ERROR at line 1:
ORA-28007: the password cannot be reused
How come I cant reuse me first password although I made more than 4 changes to user password ?
Thank you :)