When you forgot the password of SAP* user on a certain client on SAP, you could always reset it by deleting its record on your database.

DELETE FROM <db name>.USR02
WHERE BNAME=’SAP*’ AND MANDT=’<client no.>’

On the script above, <db name> is the database name of your system which is usually the same with system id and <client no.> is of course the specific client you want a password reset of SAP* user. Let say my system id is “flq” and i want to reset the password of SAP* on client 100, my script would be like this:

DELETE FROM flq.USR02
WHERE BNAME=’SAP*’ AND MANDT=’100′

Once you successfully run this script on your database, you could now log on to your system on a specific client by using SAP* and password = pass.

Note: SAP* user is activated when parameter login/no_automatic_user_sapstar is set to 0(zero).