Reset User type for SAP* & DDIC in 000 client

[former_member192421]

Hi Guys,

Mistakenly I have changed the user type of SAP* & DDIC user in 000 client from Dialog User to Service.

Is there any way that I can change this back to normal?

Thanks in Advance

Rajkumar

[Former Member · Accepted solution]

you can delete SAP* in client 000 . This should reset the user and then you can login with the default password.

Amit

[SreeniC]

Hi Rajkumar,

Please try the below procedure to change user type.

(A)Check the field value of User type

desc sapsr3.usr02;

(B)Check what is the USTYPE of sap* in client 000. A-Dialogue

select uflag,USTYP,bname,mandt from sapsr3.usr02 where bname='SAP*'

(C)Change the UST field to A i.e Dialogue User

update sapsr3.usr02 set USTYP='A' where bname='SAP*' and mandt='client no';

Thanks,
Sreeni

[former_member192421]

Hi All,

Deletion of SAP* user in Database level is fine but is there any other way around?

Regards,
Rajkumar

[Former Member]

Unless you have another dialog user available on the 000 client, the only option is deleting the SAP* user on the database level:

Delete from schema(SAPSID or SAPSR3).usr02 where bname = 'SAP*' and mandt = '000'

Then, you'll be able to logon using the "PASS" password and change the DDIC user to Dialog type (as well as changing the SAP* password).

Don't forget you need to have the following parameter configured on the profile:

login/no_automatic_user_sapstar = 0

[Former Member]

Hi Rajkumar,

Goto SU01 and change the user types. No idea why is this an issue.

Regards.

Ruchit.

[former_member192421]

Hi Ruchit,

Thanks for your reply but the thing is I am not able to login.

When I type the user name & password, in the status bar it's showing "Log on with a Dialog user".

Then the screen stops there itself. Not able to view all those menus.

Then how can I execute SU01 (any other ways)?

Regards,

Rajkumar

[Former Member]

Hi Rajkumar,

Are you sure that you have changed the user type to service user or system/communication users.

Well if it is system/communication then you can attemp changing the user type at database level using SQL query.

Regards.

Ruchit.

[former_member192421]

Hi Ruchit,

I remember correctly, I have changed it to Service user.

Anyways many thanks for your input. Deletion of SAP* user at the database level solved my problem.

Regards,

Rajkumar