Put Hexa value of your password
update sapsr3.usr02 set bcode='7765737465726e' where mandt='000' and bname='DDIC';
Bcode= ( hexa value of your password)
Unlock User:
update SAPSR3.USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000;
Commit;
Delete SAP* user
=========
Pls set the value of parameter login/no_automatic_user_sapstar= 0 in both the default profile and the instance profile and restart the instance. So automatic login of sap* with default password will be enabled.
update sapsr3.usr02 set bcode='7765737465726e' where mandt='000' and bname='DDIC';
Bcode= ( hexa value of your password)
Unlock User:
update SAPSR3.USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000;
Commit;
Delete SAP* user
=========
sqlplus “/ as sysdba”
SQL > Delete from SAPSR3.USR02 where MANDT=’000’ and BNAME=’SAP*’;
Pls set the value of parameter login/no_automatic_user_sapstar= 0 in both the default profile and the instance profile and restart the instance. So automatic login of sap* with default password will be enabled.
