Thursday, 29 December 2016

How To Reuse Same Password When its Says ORA-28007: the password cannot be reused

I am at the situation where I wanted to use same password when its expired but its using password Verify function it wont let me use same password when i am trying to use same password its giving below Error.

ORA-28007: the password cannot be reused


To reuse the same password I followed below steps.


Step 1) get the what profile is assigned to user currently 


SQL>  select profile from dba_users where username='SYSTEM';

PROFILE
------------------------------
DBA_PROFILE



Step 2 ) create the tempoary profile with password reuse unlimited.


 create profile temp_pass LIMIT PASSWORD_REUSE_MAX UNLIMITED;


step 3) Assign newly created profile to user


 alter user SYSTEM profile temp_pass;


step 4) reset User the password as old now. 


alter user system identified by XXXXXXX;


Step 5) Assign original(previous) profile to user now. 


 alter user system profile DBA_PROFILE;


Step 6) verify the profile is assigned or not. 


select profile from dba_users where username='SYSTEM';

PROFILE
------------------------------
DBA_PROFILE

No comments:

Post a Comment