How to reset SAP* user in S/4 HANA or SAP on HANA

Reset SAP* user when SAP is running on HANA Database

We are aware of the process to reset SAP* user in other SAP databases such as Oracle, MSSQL, Sybase etc.

This Blog contains the information to get the sap* user unlocked when your are running SAP on HANA database.



Step 1. Get the DB schema name. Login to SAP system and then Go to System -> Status

Pick up the schema user and schema name as shown above.

Here Schema name and user name is SAPABAP1


Step 2. Login to HANA studio with SAPABAP1 as a user name

Right click on Database Connection and click on "Open SQL Console"







Step 3 : Execute Query in SQL console to display user first and then proceed with Update or Delete as needed.


a. Run select query to confirm whether you are on right path or not.

            select * from USR02 where bname = 'SAP*' and mandt ='000'

b. Run Update query to Unlock the user by resetting the UFLAG

            update USR02 set uflag=0 where mandt='000' and bname='SAP*'


This query will unlock the user SAP* user in client 000
You can do the same for other client or user

c. Run delete query to delete the user SAP* from Client 000 (If you don't know the password)

              delete from "SAPABAP1"."USR02" where bname = 'SAP*' and mandt ='000'

Step 4. (Optional) This is for the users who has opted for deletion

Set the value of parameter login/no_automatic_user_sapstar to 0 and restart the SAP instance.

You will be able to access SAP* through pass as a password.