Unlock sap* from another client

Updated May 18, 2018

Friends,

Please provide the steps to unlock sap* from another client.
Suppose if sap* is loked in 000, how can i unlock it from 001 or other clients.

Regards

Comments

04 Sep 2009 3:03 am rekha
The user data is completely client dependent and its not possible to access the user to lock or unlock from one client to other.

But you can do it from Database instead as this is known to everybody.

04 Sep 2009 3:05 am rekha
I don't think there is any way to unlock sap* from another client , all you can do is you cal delete the entry of sap* from the client in which it got locked and then try to login thru sap* with pwd pass

04 Sep 2009 3:05 am saperpguru
Just Delete the Client 000 and restart the system. It would take the default user name and password and retrive the client too. I tried for SAP R/3 4.7 only.

04 Sep 2009 3:05 am saperpguru
or use Solution Manager for Higher versions.

04 Sep 2009 3:08 am rekha
You cannot unlock sap* password using another client. Using SQL Query to delete the sap* user id. After login sap* with default password “pass”.

05 Sep 2009 6:38 am Shalesh Singh Visen
You can unlock the sap* user....
unlock from DB level as per the steps given below

1. Logon to database server and switch to ora user. Start the database server manager with the sql prompt.Now you're able to execute SQL statements:

2. to view the entries of the "sap*" user you need to execute a sql statement for that select MANDT, BNAME, ..............................*';

3. To simply unlock SAP* in client 000, without having to delete it: use update sql statement u can update that record. u need to update the uflag field thats it

4 exit 𐃆 exit the server manager