sap* user id unlock

How to unlock SAP* user id.

As a Basis Consultant many times we require to unlock or rename SAP* user id in system.
Providing few oracle sql command to rename or unlock the SAP* user id

Rename SAP* user id

update sapsr3.usr02 set bname='SAP*1' where bname='SAP*' and mandt='500';

and then try to login into client from SAP* user id. Default password is pass

Unlock sap* user id.

update sapsr3.usr02 set flag=0 where bname="ddic" and mandt='500';

or

update sapsd1.usr02 set uflag=0 where bname='SAP*' and mandt='220';

To check the status of SAP* user id
select status from sapr3e.usr02 where bname='SAP*' and mandt='220'

Delete SAP* user id.

delete from sapsr3.usr02 where bname='SAP*' and mandt='020';