Client 001 : sap* and DDIC locked

[Former Member]

Good Afternoon Everyone,

In client 001 , both users sap* and DDIC are locked due to incorrect login attempts. I am unable to login into client.

Please suggest a way how I can login in to the client to reset sap* and DDIC.

I have no other user ID created in 001.

Have a Good Day!!

Thanks in advance

Kumar

[Former Member · Accepted solution]

Hi Hemanth,

Login as OS user <SID>adm

goto command prompt type sqlplus "/as sysdba"

and <b>DELETE * FROM SAP<SID>.USR02 WHERE BNAME='SAP*' AND MANDT=001</b>

SAP* user will be deleted and recreated again with password <b>pass</b>

Then login with sap* and goto su01 --> unlock user ddic

Regards,

Suraj

[Former Member]

Hi,

You can delete sap*

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAPSR3.USR02 WHERE MANDT='CLIENT.NO' and BNAME=SAP*;

after doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).

Note: points always encourage me reply!!

[Former Member]

hi anyone else who can help me to unlock my sap-bi 07 password .

actually i forget and DDIC OR SAP is also not working when i entered the password 06071992*

and 19920706 both the things i have tried but still having the same problem.

please help me soon ...............

[Former Member]

hi anyone else who can help me to unlock my sap-bi 07 password .

actually i forget and DDIC OR SAP is also not working when i entered the password 06071992*

and 19920706 both the things i have tried but still having the same problem.

please help me soon ...............

..............

-

---

[Former Member]

Hello,

If your database is Oracle, then please execute the above sql query to activate SAP*/pass logon for the client you want (for e.g. 000) and above profile parameter should be set as '0'.

Thanks

[former_member186955]

to be precise, the following worked better for me:

delete from SAPSR3.USR02 WHERE MANDT='000' and BNAME='SAP*';

delete from SAPSR3.USR01 WHERE MANDT='000' and BNAME='SAP*';

regards

mateusz