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

You want to find out which users have an access to a particulat transaction. How would you do that?

639


Hi I am new in this forum and in this practice. can anyone help me out in finding out how to get training material for SAP CRM 2007.

1765


What is the database backup strategy in your company?

1741


describe how to setup a printer in SAP or where they would look to research why a user/users can not print?

644


Explain domain controller?

723






If brtools is not working how you will add datafile?

2056


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

597


What are the regular activities u do in solution manager and how

1620


What are the errors you got while applying support pack?

1377


What are patches you applied?

799


How do you solve oracle archive struck?

1465


Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

786


What is transport domain?

1412


before doing client copy you have to adjust table space at os level.what is the single command for that?(with out going through all the menu of brtools)

1727


what is garbage collector. is there any way to set the time to gc?

3622