SAP* Password Reset

12Jul08

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).


One Response to “SAP* Password Reset”  

  1. 1 monish

    i am a new user. tell me to sap from begining.

Leave a Reply



Calendar

July 2008
M T W T F S S
« Jun   Dec »
 123456
78910111213
14151617181920
21222324252627
28293031