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