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-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...