Can anyone tell me How to lock a single client from sap
level and from o/s level?How to lock users from o/s level.

Answer Posted / rajeev.meetme@gmail.com

From OS Level
sqlplus / as sysdba
SQL>update SAPSR3.USR02 set UFLAG=64 where BNAME='XXX' and MANDT='XXX';
UFLAG=64 means lock
UFLAG=0 means unlock
BNAME=User Name
MANDT=Client Number

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can disable the ‘import all’ button on stms for the queues?

649


Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?

1926


Explain what are the functional modules used in sequence in bdc?

590


please share sap basis admin interview questions .. thanks sadik

874


Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance

2107






How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?

2707


What is process for applying patches?

687


i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

1663


can anyone tellme java instance startup sequence?

9092


How to analysis abap dumps?

684


Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

1926


Explain checkpoint?

557


How many times bdls transaction executes for 2 clients

1401


1)Have you used performance tuning? What major steps will you use for these? 2)In production what is the user exit? 3)What type of user exits have you written? 4)Difference between Search Helps and Match Codes 5)On which even we can validate the input fields in module progams? 6)what are the table controls in BDC ? 7)what is the difference between bdc and lsmw ? 8) If the scripts are client dependent, what above driver program ? (client dependent / independent) 9). I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 10) Will 50,000 records be uploaded directly into APP's Server? 11) What is the button to change the variant in ALV ? 12) If your project is support project ? when is your implementation has completed ? 13)In start of selection, if we perform validation, what happens ? 12)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 13)How to transfer data which is coming from are report as output to another report 14)How to create standard text and how do u transfer it ? 15)What are the views when we are creating Material ?

1937


How should I set priority for Printing say like user, teamlead, project manager?

600