RESET SAP USER ID PASSWORD!!!!!!!!!!!!!!

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

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.