Monday, March 30, 2020


ORA-28007: the password cannot be reused


SQL> SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS;

SQL> alter user ifsapp profile default;

SQL> select RESOURCE_NAME,LIMIT from dba_profiles where PROFILE='DEFAULT' and           RESOURCE_NAME Like 'PASS%'

PASSWORD_LIFE_TIME
PASSWORD_REUSE_TIME
PASSWORD_REUSE_MAX
PASSWORD_VERIFY_FUNCTION
PASSWORD_LOCK_TIME
PASSWORD_GRACE_TIME

Change all the profile limit to unlimited including PASSWORD_VERIFY_FUNCTION which should be set to null.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME unlimited;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_TIME unlimited;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX unlimited;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_GRACE_TIME unlimited;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;

SQL> alter user ifsapp identified by SHLtst$123;





No comments:

Post a Comment

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...