sap* user type change

[Former Member]

Hi,

One of our system ECC has been kept unused for a long time. I was checking it when I found out I dont have any user id to login to the default client or any other client. I tried with SAP* and PASS in one client, it shows "LOGIN WITH A DIALOGUE USER" . I dont have ddic password too. Can anyone tell me how to change the USER type from database level. Then I can try with PASS else I will reset the password from DB Level.

Thanks,

Santanu.

[Former Member · Accepted solution]

Hi Santanu,

Delete SAP* from database(Oracle) using command below

delete from SAP<SID>.USR02 where BNAME='SAP*' and MANDT='500';

set the parameter login/no_automatic_user_sapstar=0 and restart the application server.

Now, you should be able to login with SAP* and password as "pass"

Thanks,

Arjun

[Former Member]

Hi,

The issue has been resolved.

I performed the following steps:-

1. Checked whether sap* exists in client 100 (It will obviously exist but still made sure)

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

2. Check the field value of User type

desc sapsr3.usr02;

3. Check what is the USTYPE of sap* in client 100. A-Dialogue

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

4. Change the UST field to A i.e Dialogue User

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

5. Login to the system with SAP*

What it did it, it changed by SAP* user to DIalogue user. Now I logged it with the password (hit and trial).

Or we had to change the pwd from db level too.

[Former Member]

Thanks.