Reset / Unlock a user from another client

Posted on Posted in Uncategorized

Hello,

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.

1 – You must have a user in another client, if you don´t, unlock the user SAP* in 000 client through the parameterlogin/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’;

MAN BNAME
— ————
300 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

Total Views: 451 ,

Leave a Reply

Your email address will not be published. Required fields are marked *