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.

Untitled.jpg

Steps to Unlock the SAP* user (DB level)

1. Try login SAP system with SAP* user

/wp-content/uploads/2013/09/2_272128.jpg

    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

/wp-content/uploads/2013/09/4_272135.jpg

    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.

/wp-content/uploads/2013/09/31_272139.jpg

    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’

/wp-content/uploads/2013/09/51_272140.jpg

6. Now execute the query : 

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

/wp-content/uploads/2013/09/6_272146.jpg

    Now the Value of UFLAG has been altered to 0.

   

/wp-content/uploads/2013/09/last_272186.jpg

    SAP* user has been unlocked.

==========================================================

To report this post you need to login first.

14 Comments

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.

      (0) 

Leave a Reply