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;
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