on 12-15-2009 2:33 PM
All users in production client got locked mistakenly. Is there any method to unlock them? I am using SQL server as database.
Edited by: Rajkumar Namdeo Phand on Dec 15, 2009 3:34 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go to SU10 select all users and click unlock
Regards
Juan
All users along with SAP* and basis are locked. There is no way I can log in using any user id. please help.
The procedure to unlock SAP* has been posted hundreds of times.... a simple search in SDN will give you the answer.
Please search before posting.
On Microsoft SQL Server 7.0:
Start the "Query Analyzer"
Enter the database server as the host.
User: <sid>adm
Authentication: "Use Windows NT authentication"
Enter the following command and execute it:
DELETE FROM prd.[USR02] WHERE MANDT='<Client>' AND BNAME='SAP*'
Exit the "Query Analyzer"
You can now log on to the system again with user SAP* and the initial
password
how easy was that?...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.