cancel
Showing results for 
Search instead for 
Did you mean: 

lost of password

Former Member
0 Kudos

I have lost the password for SAP* and DDIC in client 000.

I tried to manually delete the user SAP* from the Table USR02 for the client 000.

After that I try to log in as SAP* and use the default password as "PASS"

It still gives me error as "User is locked. Please notify the person responsible".

Any idea what to do next?

Thanks a lot.

Amy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI amy,

First check whether the uflag is set to 64 for sap* at table level. You can use SE16 and check the entries in table USR02.

uflag =64 is locked

uflag =0 is unlocked

If SAP* uflag is 64, then you can change the settings at DB level.

1. Login to DB and at command prompt

2. use the statement

Select sapr3.usr02 where mandt=`<clnt.no>` and bname=`sap*`;

3. if the uflag is 64 then change to 0

update sapr3.usr02 set uflag=`0` where mandt=`<clnt.no>` and bname=`sap*` ;

commit work;

4. use the step 2 select statement to check whether the uflag for sap* is changed to 0.

5.Now login to SAP using SAP* with default password `PASS`.

regards,

Vinodh.

Former Member
0 Kudos

Vinodh,

Thanks a lot for reply back. Actually I did all these before I send email out. The main reason it didn't work is because the buffer was not updated. So, I restarted the system, and wahla....... it worked as it says it would.

Thank you anyway for trying to clear it out for me, and giving me tips on what to look.

Amy

And everyone who respond trying help me.......... Thank you all!!!

jawad_hasan
Explorer
0 Kudos

anybody has any idea if without restarting the system, how to update the buffers... because I have tried many ways for it .. but no success

Answers (2)

Answers (2)

former_member190272
Active Contributor
0 Kudos

Hi

Check the parameter login/no_automatic_user_sapstar= 0

Thanks

Pankaj Kumar

Former Member
0 Kudos

Hi amy,

If all the users are locked, they can be unlocked by

a) GO to command prompt type tp unlocksys <SID> pf=//usr/sap/trans/bin/TP_DOMAIN_<SID>.pfl;

b) or else try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;

this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

c) You can delete sap*

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

<u><b>Note:-</b></u>

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).

regards,

kanthi