How you will do client copy? If SAP * user is not available
at all
in your system then how u will do client copy?

Answer Posted / c00ki3

We can go to sql query and unlock the user sap*

To unlock all the users who are locked

update sapr3.usr02 set uflag='0' where mandt='<client number>';


To Unlock particular users:

update SAPR3.USR02 set UFLAG = 0 where MANDT = <client number> and BNAME != <don't lock user 1>
AND BNAME != <don't lock user 2>;


U can unlock all the users locked with uflag =64 or 128 (locked by admin or wrong pass attempt

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between oracle 9i and oracle 10g?

1518


what is your project architecture?

1835


Explain logon groups?

908


Do? If another user wants to share that lock but the user using that

1504


Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

2125


1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix

1767


What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?

850


please share sap basis admin interview questions .. thanks sadik

1108


steps to congigure CMS in XI ?

1952


What is R/3? and what is basis version?

925


how can i change access to a user who is having access for SPRO display only to change access in sPro

2108


what is the procedure for java stack upgradation?

2075


Mention what is the purpose of table usr02?

824


How do you distribute the load?

860


in oracle script @? "?" question mark means what it indicate?

2145