how to unlock the user

[Former Member]

hi all,

i have only one user in a client( for example in client 800) it got locked ,i want to unlock the user ,how to do it,can any one helpme please

i tried user sap* --- this also got locked

user ddic --- this is also got locked

i can able to login in to cleint 000 and client 810.

can any one help me please

waiting for reply..

thanks

ashok.

[Former Member · Accepted solution]

Hi,

Please login to SAP and check the profile login/no_automatic_user_sapstar. It should be set to 0.

Once you have done that you need to restart the system.

Even if this doesnt work you can delete the sap* user from USR02 table for the client 800. It will be created again automatically with password "pass".

Once you have done that you can login to the system.

Do reward points if the answer to the question is met.

Regards,

Suhas

[Former Member · Accepted solution]

hi

i cant able login into client 800 ,but i have only one user (example user called IDAADM ) which got locked and other user like sap* and ddic also got locked in client 800

but i can able to login into client 000 and client 810

my aim to unlock the user which is in client 800....

can any ome help me please...!

waiting for ur reply..

[Former Member · Accepted solution]

have you done what i had asked you to do ?

Regards,

Suhas

[Former Member · Accepted solution]

hi sub

i am new to sap can u please explain where i want to to the change in which client can u please give me a step by step procedure it will help me a lot..

waiting for ur reply..!

[Former Member · Accepted solution]

can any help me plese

how to unlock the user,,

waiting for the reply....

thanks

[Former Member · Accepted solution]

Hi.

execute following query on sqlplus of oracle

DELETE from SAPR3.USR02 where mandt='800'

and bname = 'SAP*';

then after try to login with user sap* and password pass

regards,

kaushal

[Former Member · Accepted solution]

hi kaushal,

i tried the same i can able to delete the sap* user by using above mentioned query but after deleting the user sap*

i tried to login in sap* in ecc6.0 ides in client 800 but geting as invalid login or password but earlier i got as many failure attempts so any tried in cmd like

select * from sapsr3.usr02 whre bname='SAP*' and mandt='800'.

i am geting as "0 records selected'.

please ant one help me

waiting for the reply,...

regards,

ashok........

[Former Member · Accepted solution]

Hi,

select * from sapsr3.usr02 whre bname='SAP*' and mandt='800'.

i am geting as "0 records selected'.

means SAP* user is not exists in client 800.

if you are able to login into sap client ( other then 800)

run RZ10 and edit instance profile and make following entry.

login/no_automatic_user_sapstar -> 0

save and activate instance profile.

restart sap server.

now login into client 800 with sap* and password 'pass'

regards,

kaushal

[Former Member · Accepted solution]

hi all,

thanks for every one...

now its working fine...

Regards,

ashok