Skip to Content
author's profile photo Former Member
Former Member

How to reset SAP* password?

Hi,

I don't know the password for SAP* user for our SAND server client 000, I delete the user master records from USR02 table from DB level.

After that I am able to login to client 000 of the SAND server with user ID SAP* & password pass, now the problem is that when I tried to reset the password for SAP* it gives me error 'User SAP* does not exist'.

What should I do? please suggest.

Regards,

Rajesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2007 at 03:45 PM

    SAP* generated after deleting sap* is program generated it is not stored in table USR02 so you need to create user in tcode SU01 with name sap* giving the profile sap_all and set your own password

    then try to login with this password (now pass will not work)

    Samrat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 05:55 AM

    Hi Rajesh,

    The following are the steps required in detailed.

    After login to 000 client with sap* and pass, create other user or edit ddic user and assign some other password. Give the user full authorizations. Login with this user.

    While creating user assign the adress data also, try all the various values u can give by pressing F4 key. If system does not give any other values give ur own values.

    Now, Login to 000 with that user and create SAP* again to avoid confusion with SAP*'s kernel generated and u created user.

    If there are any issues revert back.

    Regards,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vivek,

      I followed all the steps, but my problem is How I create user SAP* without entering any values in user address data of the user master record?

      As I already mentioned last name is a mandatory field in tab address data & we are unable to move ahead until & unless I enter some values in it.

      Can anybody give me proper solution for this?

      Regards,

      Rajesh

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2007 at 08:43 AM

    Hi,

    Just delete the user sap* in USR02 and restart sap. The user will be created automatically with the default password.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I delete the user SAP* from USR02 table on DB level & as samrat says I assigned last name as SAP to the SAP* when it is recreated, I think this is not a proper step to create user master record for user SAP* because it shows me the user address data & user type as dialog user.

      I need proper solution for this, Please help.

      Regards,

      Rajesh

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 08:17 PM

    Hi Rajesh,

    Just was going through this thread. I could find all of them have provided the proper solution, and you have applied the same. Now I don't really understand why are you concentrating on the address tab and making others confused as well. As per my experience it has nothing to do with any of the processes. You can even give your name. The best thing I can suggest you to create SAP* user copying the DDIC user. Where it will go straight to the Logon Data tab, just enter the password and save, your problem is solved. One more thing what you have mentioned that SAP* is showing as a dialog user, can you tell me what type of user SAP* should be, if not a dialog user. Please be advised that you cannot login into the system through GUI if you are defining this as a communication user or system user. But if you still want to go ahead with that, you can very well choose the same in the Logon Data tab.

    Hope I have answered your question.

    Regards,

    Sanujit

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      As mentioned by Sanujit, you can copy the DDIC user instead.

      I don't understand what's the problem in giving the last name as it is ur wish to give.

      But dont give SAP* as communication user since many administrators will be confused when they cannot login to SAP with sap* ID.

      Better to give it as Dialog and lock the user, if u wish not to login through sap*.

      Regards,

      Phani.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2007 at 01:02 PM

    Dear Rajesh,

    <b>

    YOU CAN NOT CREATE USER SAP* MANUALLY OR BY COPYING ANY OTHER USER...</b>.

    To reset user SAP*

    1. Set parameter login/no_automatic_user_sapstar = 0 in DEFAULT profile.

    2. Go to sqlplus, connect as sysdba and fire query:

    delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT='<CLIENT>;

    3. Restart sap services.

    Jay

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      <b></b>OF COURSE YOU CAN CREATE USER SAP* MANUALLY AND BY COPYING ANOTHER USER.<b></b>

      Just follow the instructions in the majority of the replies, and don't worry what name is in the address tab.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.