on 11-19-2011 4:01 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.