Regarding sap* and ddic

[former_member186775]

Hi team,

My Question is regarding Default users sap* and Ddic

Actually in our IDESserver we have client 811 and in that

I wanted to create users but the problem is due to some

reasons I typed passwords of both Sap* and Ddic wrong

now both got blocked and I am not able to log into the

the Client 811.So what are the possible ways for me to

come out of this ...??

[Former Member · Accepted solution]

One way is to transport the user id from another client where you know the passwords for these 2 ids, The table to transport is USR02. Another way is to delete the user id SAP* at the OS level, then you can logon with SAP* with the password PASS.

[Former Member]

Hi manjula,

To delete SAP* user, first login as --- sqlplus "/as sysdba" and say

delete from sap<SID>.usr02 where bname='SAP*' and mandt='client no.';

Thanks,

Suraj

[Former Member]

Manjula,

If all the users are locked please logon to oracle (sqlplus) and execute the following

update usr02 set uflag=0 where bname='sap user id' and mandt=811;

Tell me if the problem is solved and award points if satisfied.

Regards,

Atul