Hi all,
11.2.0.1
I always encounter this error:
SQL> alter user SYSTEM identified by MANAGER;
alter user SYSTEM identified by MANAGER
*
ERROR at line 1:
ORA-28007: the password cannot be reused
EVEN if I set everything in profile to unlimited?
SQL>
alter profile default limit failed_login_attempts unlimited;
alter profile default limit password_life_time unlimited;
alter profile default limit failed_login_attempts unlimited password_life_time unlimited;
ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Thanks