DDIC and SAP* locked due to wrong logins in Client 001

[Former Member]

Hi Sir/Madam,

I wish to know a solution as to how to unlock either of the two DDIC and SAP* as both have been locked for multiple wrong login. I am unable to enter client 001 in our local development system. Please suggest me a way out of this.

Thanks and Regards,

Harsha.

[Former Member]

Hi Raj,

Please set the parameter login/no_automatic_user_sapstar to 0 and re-start the system.

After that please use the below SQL statement if the DB is oracle.

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

Thanks,

Pundari

[Former Member]

Hi Raj,

The solutions given by all experts are tested and 100% OK. Please follow and enjoy..

LK

[Former Member]

Hi,

Follow the given sequence.

1) Check the valus of the parameter suggested by Juan in your system. If the value is 1 in your system, please set it to 0 first. By Default this is set to 1.

2) Than delete the SAP* user from the OS level using the command given by Rishi.

3) Restart your SAP system. Otherwise it wont allow you to login with user id SAP* and password pass.

After restart you should be able to login into the system.

Once your purpose is solved, please again set the parameter value to 1 to maintain the security of your system.

With Regards,

Saurabh

[Former Member]

Hi,

you can unlock the SAP* from os level with database oracle.

Use cammand this when you connect to sql promt

Delete from usr02 where bname = 'SAP*' and mandt = '001';

then after this try to login.

Thanks

Rishi abrol

[JPReyes]

You also need to check parameter login/no_automatic_user_sapstar is set to 0 so you can logon as SAP* password pass

Read SAP Notes 2383 and 68048

Regards

Juan