SapBlog.in: How to Reset SAP* Password in SAP ASE

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

SapBlog.in