RSUSR003 sap* user - Does not exist. Logon possible with PASS

[Former Member]

Dear friends,

I am running RSUSR003 report on my SAP system, and I have sap* user on reffferenc client in red with the message:

Does not exist, Logon is possible with p/w PASS. See note 2383.

The note is offering just some info, but not a solid solution.

Have you ever faced this before ?

Thanks in advance,

Jordan

[Former Member]

Jordy,

I don´t know why but some people use to delete user SAP* at database level. This is not recomended by SAP. You should follow the recomendation as per note 2383. The user must exist, but:

SAP* should not have any authorizations (empty profile list)

SAP* should be assigned a new password

SAP* should be assigned to user group SUPER.

that then deactivation of the "automatic SAP*", described in Note 68048, is executed

have a look at this:

I think if you set the parameter login/no_automatic_user_sapstar to 0 to the SAP* user will be recreated, then you can follow the instructions as per note 2383 and set the parameter again to 1.

Hope it helps,

Diego.

[Former Member]

Hello,

Problem solved, I created the user in CUA master system and than changed the pwd, the report stopped showing that error.

Thanks all for the advices.

[former_member188883]

Hi Jordy,

SAP* user does not exist in the client which you try to login. In such a case you can login with user SAP* and password "PASS".

Please check the status of user SAP* using the following sql command

SQL> select bname from <schema>.USR02 where mandt=<client No> and bname='SAP*';

Regards,

Deepak Kori

[Former Member]

Hello all,

First thanks for replies.

2nd for deepakkori:

SQL> select bname from SAPSR3.USR02 where mandt='120' and bname='SAP*';

BNAME

-

---

SAP*

SQL> select bname from SAPSR3.USR02 where mandt='110' and bname='SAP*';

no rows selected

In the client where everyhting is OK -> 120, the user appears, but in client 110, where I have the error message in RSUSR003, I have : no rows selected.

What can I do next ?

[former_member664968]

Hi Experts,

I am facing the issue of SAP* does not exist in one of our development client and unfortunately we lost all other passwords of the other users.i tried with checking the SAP* user at backend for the client and its not existing, is there any way to create or use the SAP* user in this client so that i can relese/use other users.also is there any way to reset the password of the user at the backend.

Thanks in advance for your support.

regards,

satheesh

[Former Member]

Hi,

Looks like SAP* user is active on your system with the standard password.

The user is hard-coded and is not part of UMR unless created explicitly.

Ideally, you should have the user de-activated or the password should be changed immediately (after creating explicitly)

Consider reading related notes mentioned in Note 2383.

Hope this helps.

Regards,

Varun