How to unlock Users in client from a different client

[Former Member]

Hi All,

We have multiple clients in our SAP system. Users which are in one client are not created in other client.

The issue is that one of the user has locked his account due to incorrect login attempts. We dont have any other user in the same client with which we can login and unlock the account. We have access to some other user in some other client of the same system.

Is there a way to unlock the user in that client from some other client.

Thanks,

Tirth

[Former Member]

Hi Tirthi,

All the user data will be client specific. No user can not be unlocked from different client.

If you have CUA configured, and the specific client is child system then you can unlocked or reset the user passwords from master client.

Cheers,

Bharath.

[Bernhard_SAP]

We dont have any other user in the same client with which we can login and unlock the account. We have access to some other user in some other client of the same system.

You should have the SAP*-special features available.

You have abap possibility.

You have DB-tools possibility.

b.rgds, Bernhard

[Former Member]

What could be the ABAP possibility??

[Bernhard_SAP]

...well, a little report selecting from usr02 for the corresponding client, updating the uflag field to 0 and writing it back to usr02....

Of ocurse this is bypassing any change docs etc. and not usabel for productive environements, but for emergency usage in dev/tst I think its ok.....

b.rgds, Bernhard

[Former Member]

Hi Bernhard,

Thanks, Problem solved.Its just a sandbox system, wrote a code snippet and it worked.

Thanks,

Tirth

[Former Member]

Despite the different client, there are many ways to unlock the user. We could use one of the follow...

SU01, EWZ5, or Program BAPI_USER_UNLOCK

Reference: http://www.findsap.com/blog/2012/how-to-unlock-user-in-sap-by-using-tcode-other-than-su01

Good luck

[Former Member]

This message was moderated.

[Former Member]

Hi,

You can use SAP* to login to that client. You can check from database level if profile parameter login/no_automatic_user_sapstar is set to 0 (=default value). If it does, you can login to that client with password PASS.

In case its set to 1, you have to stop SAP, change this parameter to a value of 0 (zero), and then restart SAP to login with SAP* using password PASS

Thanks

Sandipan

[jurjen_heeck]

 You can check from database level if profile parameter login/no_automatic_user_sapstar is set to 0 (=default value).

Profile parameters do not reside in the database. I suspect Sandipan meant O.S. level.

[Former Member]

Right!..thanks for the catch

[canute]

Hi,

Your solution worked, and helped me  a lot..

I set the login/no_automatic_user_sapstar to  0 and, re started the instance.

then loggedin to client 000 using SAP* and the password PASS

ps: the sustem was not connected to CUA.

[Former Member]

Hi,

i have the username and password for the client 230(suppose) but i have to login into the 210 cllient. i don't know the password for client 210. i know only the username. Please suggest that how to login into 210 client.

Thanks,

Pankaj

[Former Member]

Cant you read or are you too lazy?

[Former Member]

I didnt get the relevent reply for my query thats why i post again.

[Former Member]

Just review this post from top to bottom, you will get your answers.

[Matt_Fraser]

And also it's not necessary nor a good idea to cross-post ().

[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'

commit

And a small dbacockpit tutorial by me .