Unlock DDIC & SAP* in any Client

Hi Folks,


There will be time where people tend to forget their mater password and hence are locked out of the client.
The following method will provide steps to fix that issue.


Example: User SAP* is locked out and password of User DDIC is unknown in Client 100 of an SAP System. There are no other users than DDIC / SAP*. How do you gain access to client 100?


1. Enable login/no_automatic_user_sapstar = 0 (transaction RZ10/RZ11). This will enable you to login to any client in the system as user sap* with password as pass.


2. If the above still doesn't work, execute the following SQL to delete SAP* User which system will create again.

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

> commit;

This should allow now for sure user SAP* to login with password pass.

3. Just to unlock any user say DDIC if locked, execute the following SQL,

> update sapsr3.usr02 set uflag ='0'  where bname like 'DDIC' and MANDT = '100';

> commit;

Now Enjoy with your System.