How can I recreate user SAP*?

[Former Member]

Hello everybody,

Last week I needed to log on 000 client whit user SAP*, but I did not remember the password, so I used these sentences to restart it:

db2 "select * from sapsol.usr02 where mandt='000' and bname='SAP*'"

db2 "delete from sapsol.usr02 where mandt='000' and bname='SAP*'"

Now I can log on to 000 as SAP, but jobs defined previously for this user are canceled and the message "Logon of user SAP in client 000 failed when starting a step" appears in the log.

I tried to create it using SU01 but it fails and the abap dump "SAPSQL_ARRAY_INSERT_DUPREC" is generated, which indicates "The ABAP/4 Open SQL array insert results in duplicate database records."

What can I do?

Thanks in advance.

[nirmal_konchada · Accepted solution]

Hi,

You need to create SAP* from database level as mentioned by you earlier.

Coming to Jobs...are the jobs still getting cancelled now???

Regards,

Nirmal.K

[Former Member · Accepted solution]

Hi,

Jobs are runnig now for user sap* and I can log on as it, but I can not see it in SU01 or change its password from log on screen.

Thanks a million.

[Former Member · Accepted solution]

You need to create a sap* user in SU01 then only you will be able to change the password or can see in the list.

[Former Member · Accepted solution]

Hi,

I created as you said, all is fine now.

Thanks and Best regards.

[Former Member]

You will not be able to create the sap* user in SU01.

You should be able to change the user for the step defined in the job from SAP* to another userID (may be batchadm)