SQL> alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxxx';
alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxx'
*
ERROR at line 1:
ORA-28007: the password cannot be reused
alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxx'
*
ERROR at line 1:
ORA-28007: the password cannot be reused
=========================================================
Solutions:-
1)Change the profile limit and make the same password
SQL> select USER#,NAME,PASSWORD FROM user$ where name='BACMONIT';
USER# NAME PASSWORD
---------- ------------------------------ ------------------------------
99 BACMONIT XXXXXXX
2)Check the PASSWORD_REUSE_TIME.
SQL> select * from dba_profiles where profile='DBUSER' and RESOURCE_NAME in ('PASSWORD_REUSE_TIME') ;
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DBUSER PASSWORD_REUSE_TIME PASSWORD
360
3)Change the profile limit to unlimited.
SQL> alter profile DBUSER limit PASSWORD_REUSE_TIME UNLIMITED;
Profile altered.
4)Change the password with used one.
SQL> alter user BACMONIT IDENTIFIED BY VALUES 'xxxxxxx';
User altered.
5)Revert back the limit.
SQL> alter profile DBUSER limit PASSWORD_REUSE_TIME 360;
Profile altered.
6)Check the password expiry date
SQL> select username,account_status,EXPIRY_DATE from dba_users where username='BACMONIT';
USERNAME ACCOUNT_STATUS EXPIRY_DA
------------------------------ -------------------------------- ---------
BACMONIT OPEN 29-DEC-13
No comments:
Post a Comment