DB version: 11.2
OS : Solaris 10
We have a password verification function by which a password can be reused only after 50 different password changes.
But I want to disable this verification and re-use a password .
SCOTT user's profile is DEFAULT. I set DEFAULT profile's password verify function to NULL
select profile from dba_users where username = 'SCOTT';
PROFILE
------------------------------
DEFAULT
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Profile altered.
SQL> select * from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
SQL> password SCOTT
Changing password for SCOTT
New password:
Retype new password:
ERROR:
ORA-28007: the password cannot be reused
I tried the below as well, but still getting ORA-28007 error
alter user scott identified by xxxx ;
Any idea why this is happening?