How to Reset SAP* Password in SAP ASE

How to Reset SAP* Password


It is often that we may forget or miss the password for User SAP*. Here you can see how to reset the SAP* password 

The following below steps shows how to Reset the Password for SAP*


1) Parameter  login/no_automatic_user_sapstar = 0 

     Set the Value to 0 (ZERO)
     after you reset the password make the value to 1

2) Reset Password


     I)Login to the DBADMIN in OS

   Logon to database server and switch to ora user (e.g. oraalr) under UNIX ( under Windows).

if your SID is PA1 then it should SYBPA1 login



    II)Login to the Database Server with command
        ISQL -U -S -P -X

    III)Execute SQL statements
Now you're able to execute SQL statements:

       a) view the entries of the "sap*" user type in following command:

       select * from .usr02 where mandt = '000' and bname = 'SAP*'; (maybe you have to change "mandt" to your client)

is the owner of the DB .

      b) Delete the "sap*" user type in the following commands:
delete from .usr02 where mandt = '000' and bname = 'SAP*'; (maybe you have to change "mandt" to your client)
commit;
exit à exit the server 

 3) Restart the SAP INSTANCE 

 4) Login to the Client 000 with SAP* Password as pass

      Change the password  and reset the Parameter value to 1


here client 000 is for example you can apply to any client in the