Skip to Content

Whenever SAP* user got locked (mainly in 000 Client), in most cases we are supposed to unlock the SAP* User in database level.

Before logging into SAP system using SAP* user, be aware whether the parameter login/no_automatic_user_sapstar is set to value 0 (Zero).

If the value of parameter login/no_automatic_user_sapstar is set to 1, it will not allow the SAP* user to login to the SAP system.


Steps to Unlock the SAP* user (DB level)

1. Try login SAP system with SAP* user


    SAP* user got locked due to too many attempts with wrong password.

2. Login to Ms SQL Database,

3. Execute the query:


     select * from er1.USR02


    The status of the user is locked/Not locked is identified in the field UFLAG.

    In the above screenshot, value of UFLAG is 128 for the user SAP*, means the SAP* user got locked.

    Note : If the value of UFLAG results in a Non-Zero value, then it means that the user got locked.

4. Execute the query: 

     select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’ to find the details of only SAP* user.


    For Unlocking the user, the value of UFLAG should be set to 0 (Zero).

5. Execute the query: 

    update er1.USR02 set UFLAG=‘0’ where BNAME=‘SAP*’ and MANDT=‘000’


6. Now execute the query : 

    select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’


    Now the Value of UFLAG has been altered to 0.



    SAP* user has been unlocked.


To report this post you need to login first.


You must be Logged on to comment or reply to a post.

    1. Luis Darui

      Hi Javed, you should seek similar information in the following space:

      SAP on Oracle

      I don’t work with Oracle but it seems to me that the tables are the same, so you would need to use sqlplus or other Oracle tool to connect to DB.


Leave a Reply