ALL USERS LOCKED INCLUDING SAP*&DDIC

[Former Member]

Hello Experts,

All users including sap* and DDIC got locked on my 000 client with the T.C EWZ5. How do i unlock them? plzzz help me

[Former Member]

Hi,

Try deleting the record corresponding to SAP* from the table USR02.

Logon to some other client

Execute the query

DELETE FROM USR02 WHERE MANDT='CLIENT NO' AND BNAME='SAP*'

once the record is deleted, try logging in with the userid: <b>sap*</b> and password:<b> pass</b> after that you can unlock the other user id's (in tc su01)

Regards,

sowmya

[Former Member]

Hi ,

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

a)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><b>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;</b> this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

b) You can delete sap* user

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

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

<b>Note:-

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

regards,

kanthi

[Former Member]

If login/no_automatic_user_sapstar=1 then you can manually edit the default.pfl file to fix that before bouncing the box & logging in with SAP*

>

> <b>Note:-

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

>

[Former Member]

Thanx for ur replies..i'll try the above suggestions....I'm new to SAP so can you plz tell me what are Bname , uflag, mandt, and some information on 'usr40'...

and at last where can i access usr02...waiting for replies...Thnxx

[Former Member]

BNAME is the UserID field in table USR02

UFLAG is the lock status entry for a UserID in table USR02

MANDT is the SAP client that the ID is locked in

USR40 is a table that contains the list of forbidden passwords. You can put values in here that users are not allowed for their passwords.

e.g.

MONDAY

PASS*

etc

You have to update table USR02 via SQL as per Kanthi's instructions

[Former Member]

thanx alex,

just one last question!! What does schema mean in SAP