ddic and sap* users are locked in client 000.

[Former Member]

Hi,

Due to repeated worng logons users ddic and sap* are locked in client 000.

I tried with some steps, like;

update SAPAPS.USR02 set bname='SAP1' where bname='SAP' and MANDT='000';

but still i am not able to log on to the client 000 with the user sap* and password pass. I don't have any other users in this client. So i am not able to log on this client.

Your suggestions are really valuable for me.

Regards,

Dhananjay

[Former Member · Accepted solution]

Hi,

If you have deleted the user sap* in the DB level,and have set the parameter

login* and still sap* doesn't work with pass.

Run /$tab or \$tab in any client in SAP system.As USR02 is a buffered table it resets the

buffer.

Plz check if it helps.

Regards,

Abhishek

[Former Member · Accepted solution]

Hi,

Thought i reset the UFLAG of table USR02 from 128 to 0.

Saplogon is still saying that "password logon no longer possible- too many failed attempts".

There is no effect of deleting the sap* user or unlocking the sap* user.

I think sap user datas are updated in some other table other than USR02.

Regards,

Dhananjay

[Former Member · Accepted solution]

Hi

Did u restart the instance, once we had a problem it is done

or else

u have to delete the sap* user at the database level for the desired client and it will allow you to login with password Pass.

All the best

Regards

Bhaskar

[Former Member]

Hi Everybody,

I restarted the system, then i was able to log in with SAP*.

Thanks for every body, for your valuable tips.

Regards,

Dhananjay

[marcelo_sehnem]

Hi,

In order to revert user SAP* to its original password you will have to

delete the user master record of SAP* at database level (using database

utilities as database administrator) and then you should be able to

logon to client 000 as SAP* with password PASS

To do this, log on to the database and issue the following SQL statment:

delete from usr02 where mandt='000' and bname='SAP*';

Regards,

Marcelo

[Former Member]

hello,

i'm a telling u a simple way try it.

if u ve any other user then login through that user id n run tcode " su01" n unlock sap* and ddic . if u ve forgot the previous password then change it.

[Former Member]

Dear Dhannjay,

To Change Password using Database Queries from OS level :

Fields:

Uflag u2013 lock/unlock status

0 u2013 unlock

64 u2013 locked by system manager.

128 u2013locked due to incorrect login

Bname u2013 User ID

Bcode u2013 encrypted password

Mandt u2013 Client Number.

Procedure

SQL> select * from SAPSID.usr02 where bname = u2018useridu2019 and mandt = u2018clientu2019;

This gives the details of the specified user ID in the given client

SAPSID is the database schema.(SID : Your system SID)

To unlock user ID :

SQL> update sapsid.usr02 set uflag = 0 where bname = u2018sap*u2019 and mandt = u2018001u2019;

SQL> commit;

This will unlock the ID sap* of 001 client.

To change password

First copy the password of any ID that you are aware of :

For eg :

SQL> Select * from sapsid.usr02 where bname = u2018BASIS and mandt = u2018500u2019;

MAN BNAMEu2026u2026.BCODEu2026u2026u2026u2026..

u2026u2026u2026u2026

u2026u2026u2026u2026

500 BASIS F3E8u2026u2026u2026u2026u2026u2026. (Encrypted password)

Now change the password of the required ID:

SQL> update sapsid.usr02 set bcode = u2018encrypted passwordu2019 where bname = u2018BASISu2019 and mandt = u2018001u2019;

SQL> commit;

Now login to sap,

Run tcode u2018/$syncu2019

This will reset the buffers. Now the password of basis will get updated.

Regards,

Rahul.

[Former Member]

Please refer to this thread.

link :

[Former Member]

Dear Dhananjay,

Have you set login/no_automatic_user_sapstar = 0 in the instant profile?

If no then change this first and do the steps you previously performed.

If yes then please mention the steps you performed

Regards,

Ashutosh

[Former Member]

Hi Ashutosh,

The parameter login/no_automatic_user_sapstar = 0 in Instance profile.

If i delete sap* in 100 client it works fine, i am able to log on with the password pass.

But with client 00 it is not logging in with the user sap* and password pass.

Regards,

Dhananjay

[Former Member]

Hi,

You might be missing something. I have done this and you are also in the right way.

Proceed carefully it will happen.

Regards,

Ashutosh