SAP* deleted from DB2

[former_member201054]

Hi ,

I have deleted SAP* (000) user from DB2 level with the thought of resetting password.to "PASS"

Now its not showing up in USR02 table.

how to recover it and login as SAP*..please help.

Thanks in advance

[Former Member · Accepted solution]

Please make sure you have following parameter set in SAP and restart system

login/no_automatic_user_sapstar = 0

If you don't have any other user to login to GUI, change from OS and restart system. Then you can login using PASS for SAP* . Once done, change the param value back to 1 after resetting SAP* to non-default password.

Thanks