Logon Failure

[Former Member]

Dear All,

Im using CRM Ides, i have client 001 and 000, i cannot logon to 001 client due to too many failed attempts and wrong passwords, whereas i can logon to 000 client.

I tried with DDIC/IDADMIN, it says too many failed attempts, logon no longer possible.

can somebody help me to solve this issue, there is no users been created apart from the standard users.

is there any way of creating another client from 000 client, points will awarded.

Regards

Felix

[Former Member · Accepted solution]

Hi Felix,

Table Name : usr02

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.

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 = u2018DDICu2019 and mandt = u2018000u2019;

MAN BNAMEu2026u2026.BCODEu2026u2026u2026u2026..

u2026u2026u2026u2026

u2026u2026u2026u2026

000 DDIC F3E8u2026u2026u2026u2026u2026u2026. (Encrypted password)

Now change the password of the required ID:

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

SQL> commit;

Now login to sap,

Run tcode u2018/$syncu2019

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

Regards,

Rahul.

[Former Member · Accepted solution]

Hi Rahul,

Thank you for the reply, however my knowledge with regard to SQL is very limited, can you please guide me step by step to solve my issue.

Awaiting your reply.

Regards

Jude

[Former Member]

Hi Jude,

Type at command prompt sqlplus /nolog

then conn /as sysdba

Try this.

Regards,

Rahul.

[Former Member]

Hi Guys,

Thank you all for the reply, however, my knowledge on sql is limited, can you please guide me step by step to achieve this error.

Awaiting for the reply.

Thanx and Regards

Jude

[Former Member]

Hi Jude,

open a command prompt from o/s level and execure below commands.

sqlplus "/as sysdba"

sql > DELETE <schema>.USR02 where MANDT='001' and BNAME = 'SAP*';

put the value of the schema as per your setting.

It can be your SID or sap<SID>

This will reset your sap* user password to pass

Now you can login to the system with user sap* and pass.

Regards

Ashok

[Former Member]

Hi,

Before deleting the SAP* user check out the profile paramnter login/no_automatic_user_sapstar = 0 it should be set to 0 only then it would allow you to login with sap* and pwd as pass.

dfault value for login/no_automatic_user_sapstar will be set to1

hence make the changes to 0 and delete the sap* user and try logging in.

[Former Member]

Hi Ashok,

Thank you for the reply, I got into command prompt, i typed sql "as sysdba" and it asks me for the username and pasword and thats it, it comes out of the loop, can u please guide me step by step.

Regards

Jude

[Former Member]

Parameter login/no_automatic_user_sapstar = 0 must be set in the instance profile and the system must be restarted before it's activated.

login to sql prompt

sql > DELETE sid.USR02 where MANDT='001' and BNAME = 'SAP*'

next time you login you can use default password .

it will definately work

reagrds

dEE

[Former Member]

Hi,

Once you are logged in 001/000, make sure you do create your user id from Emergency point of view, this user should be having SAP ALL & SAP NEW profile, as this will help you to log in to the client whenever you have issue & also in case of Password failure.

As enabling SAP* password requires system recycle, so it's better to have Emergency user, which will save your Recycling of system.

[Former Member]

Hi Jude,

You can unlock the users from the DB level. Users data will be stored in the usr02 table.

Try by using oracle sql statements to inloack the user ids.

Thank You,

Mahesh C