Skip to Content
avatar image
Former Member

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

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

Posted: Mar 21, 2007 10:07 AM Reply E-mail this post

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

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Mar 21, 2007 at 05:10 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 05:22 AM

    Hi Somya,

    i guess u have locked all users including sap* and logged out. ie., no more login with sap* also.

    in this case,

    goto DB level and delete sap* user.

    and try to login sap* with default password.

    then unlock all users.

    it will work shure.

    Cheers,

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2007 at 12:07 AM

    You can also update the table with abap by logging in to another client and using the CLIENT SPECIFIED option.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 02, 2008 at 06:24 PM

    Guys,

    Use tcode EWZ5 and select all the users, there is option to select all in the tcode screen and hit unlock.

    You can use this tcode to both lock and unlock all or some users.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 04, 2008 at 10:24 PM

    Hi Saumya,

    Follow the link

    How to retrieve the password of client 800

    this might be useful.

    Thanks,

    Debasis.

    Add comment
    10|10000 characters needed characters exceeded