Skip to Content
avatar image
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 rechme.saumya@gmail.com .

Regards,

Saumya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 21, 2007 at 05:08 AM

    Hi,

    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> ;

    commit.;

    This unlocks all the users.

    update sap<sid>.usr02

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

    commit.;

    This unlocksonly the user xxx.

    This will resolve your problem.

    Pl dont forget to award points.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 client.so, try for every client in that sap system.

    This might help u to reolve ur issue.

    Regards,

    Kanthi kiran. D

    Add 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???