Skip to Content
Author's profile photo Former Member

Reset / Unlock a user from another client



Just sharing a tip:


The user that you trying to log on is locked, or you don´t know the password anymore, plus, you don´t have any other user on that same client, and you cannot restart the system to change the parameter login/no_automatic_user_sapstar.


Important: this is not usable for productive environments, you should use SAP documentation. Easy way with SAP*.


1 – You must have a user in another client, if you don´t, unlock the user SAP* in 000 client through the parameter login/no_automatic_user_sapstar = 0.



2 – Logon the database with SQLPlus, and with those commands below, you going to change the CLIENT of your locked user (example user: BASIS) to another client, in this case, from 300 to 000:



SQL> select MANDT, BNAME from sapsr3.usr02 where BNAME = ‘BASIS’;



— ————



SQL> UPDATE sapsr3.usr02 SET MANDT = ‘000’  where BNAME = ‘BASIS’ AND MANDT = ‘300’;


1 row updated.


SQL> commit;


3 – Now, we logon on the 000 client, with SAP* (or another user) and reset the password/unlock the BASIS user on SU01 tcode.


4 – Now just back the change you made earlier on database:



SQL> UPDATE sapsr3.usr02 SET MANDT = ‘300’  where BNAME = ‘BASIS’ AND MANDT = ‘000’;


1 row updated.


SQL> commit;


That’s it, now the user BASIS is unlocked (or password reset) on the CLIENT 300.



Best Regards,

Richard W. L. Brehmer

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Praveen Ninan Alex
      Praveen Ninan Alex

      Good one.



      Author's profile photo Beyhan MEYRALI
      Beyhan MEYRALI




      Open tcode dbacockpit on any other client and go to SQL Editor and run


      To check data

      select * from USR02 where bname = 'XXXXX'

      To fix data

      update USR02 set uflag = '0' where mandt = '010' and bname = 'XXXXX'


      And a small dbacockpit tutorial by me .