Reset / Unlock a user from another client

[Former Member]

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. 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';

 

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