Skip to Content
author's profile photo Former Member
Former Member

How to unlock users in a SAP system if all of them are locked

Hello Experts,

In any SAP System,if a user having authorizations has mistakingly locked all the users of the SAP system,then how wll we unlock those users bcoz we wont be able to logon into the SAP System. Requested to revert your valuable replies at earliest.This happened with us,how to resolve it.My Email Id is .



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 21, 2007 at 05:08 AM


    If all the users are locked , they can only be unlocked via sql.

    Actually waht happens is if the uflag field of an user in table usr02 is 0 then the user is unlocked. Different values of the uflag field in table USR02 mean:

    0 User not locked

    32 Locked by CUA central administrator

    64 Locked by administrator

    128 Locked after failed logon

    Incase all the users are locked execute the following sql to unlock them

    update sap<sid>.usr02 (means update sapd01.usr02 or sapq01.usr02 etc)

    set uflag='0' where mandt = <client no> ;


    This unlocks all the users.

    update sap<sid>.usr02

    set uflag='0' where bname='xxx'and mandt =<client>;


    This unlocksonly the user xxx.

    This will resolve your problem.

    Pl dont forget to award points.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 21, 2007 at 06:38 AM

    hi somya,

    I hope this information helps for resolving ur issue

    coming to the issue TRY logging with SAP* or DDIC if at all u have those users unlocked or else try this one

    go to command prompt type <b>tp unlocksys <SID> pf=//usr/sap/trans/bin/TP_DOMAIN_<SID>.pfl;</b>

    or else try this command at ur sql plus query level

    <b>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;</b>

    this statement actually unlocks the users of that particular, try for every client in that sap system.

    This might help u to reolve ur issue.


    Kanthi kiran. D

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi manas

      i have a question

      created new password in t.c. su01.

      go to the sap log on

      entered the new password

      after entering the password

      a pop up screen displayed with contents new password and repeat password though i was already created the new password

      i want to supress ths pop up screen so tht pop up screen ll nt displayed after entering my new password

      how do i do???

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.