How to reset SAP* password?

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Samrat,

Thanks for reply,

When I check address data for SAP* user in our development server it shows that address data is not available for the user SAP*, we can assign the profile SAP_ALL to the same.

Problem is that when I tried to create the user SAP* using su01 it gives me directly address tab in which last name is a mandatory field, I am unable to go ahead without inserting any value in this, can you suggest any solution for this.

Regards,

Rajesh

[Former Member · Accepted solution]

give last name as sap

in this tab this is must

and in the next tab you need to enter the password

and go to profile tab giva sap_all

Samrat

[Former Member]

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

[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.

[Former Member]

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

[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.

[Former Member]

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.

[Former Member]

Hi Phani,

Thaks for reply,

I followed the same steps & user SAP* is created, But as I mentioned I dont want user address data for User SAP*, which displays the last name as SAP.

Regards,

Rajesh

[Former Member]

Dear Rajesh,

Logon to SQL then use

delete from <SID>.USR02 where BNAME='SAP*' and MANDT='<client number>'

Then set login/no_automatic_user_sapstar = 0 in Instance profile.

Restart the system.

You will be allowed to logon to the system using SAP* and password pass.

Thanks & Regards

Vivek

[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

[Former Member]

Hi,

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

[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