reset SAP* user in DB2 database

[Former Member]

hi gurus,

Can anyone give me instructions or commands on how to reset sap* password in the database level? we are using db2 ver. 9 database. I am familiar how it is being done in oracle but one of our client is using DB2 and there, we encountered the problem.

Pls. advise.

Best regards,

Jay

[Former Member]

hi guys,

thanks for the reply. But my database is DB2 ver 9 not oracle.

thanks

[Former Member]

Hi

First make sure that the parameter

<b>login/no_automatic_user_sapstar is set to 0 (false)</b>

otherwise you will not be able to login using SAP* by the default password "<b>pass</b>". So make this sure before carrying out the following activity:

Log on to the database with userid <b>ora<sid></b> and

execute the following SQL:

<b>delete from sap<SID>.usr02 where bname='sap*' and mandt='XXX';</b>

<b>commit;</b>

Once this is done check the entry again in the table usr02.

Now try to log into the corresopnding client with user "<b>sap*</b>" and password "<b>pass</b>".

This is how you can reset SAP* user at the database level.

Regards,

Sumit

[former_member190272]

Hi

Login SQL Pluse and delete sap* table usr02 .After restart system it will automatically create new password.pass

Try login user name

Sap* Passward pass or 06071992.

if u can login DDIC u can change sap* password.

Awards point if helpful

Thanks & Regards

Pankaj Kumar

[ankur_garg5]

Hi Jay,

Go through this thread:

Bye

Ankur

Please reward points if it helps!!