Hi, SAP* ID is locked.

[Former Member]

SAP ID is locked*. What can I do?

[Former Member]

Hello Vasu,

Goto usr02 table and delete the password for sap* and restart the SID and now logon with sap* as 06071992.

If you have any other id then you can logon with that id and reset p/w for sap*

Rewards point if solution works.

Regards,

Rohit Mehta

[Former Member]

Change the profile parameter

login/no_automatic_user_sapstar

for your system .

or create one user in your system by name SAP* in Su01.

Award if helpful ...

Shailesh

[Former Member]

Hi,

If you don't have any other super user ID's to unlock it,then you can delete the sap* from the DB level.

Delete * from usr02 where bname=sap* & mandt ='<clinet>' ,then you can login to the system wilth sap* with the default password pass.

Regards,

sam

[blair_towe2]

Good morning, Shailesh - If SAP* is locked and you know the password, you can log in to the database and in the R/3 schema run the following command:

select MANDT, UFLAG from USR02 where BNAME='SAP*';

You will get a listing of the clients in your system and the contents of the UFLAG field. A '0' means the user is unlocked, a '64' means the user is locked. So, for example, if the user is locked in client 100, you could then run the following command to unlock them:

update USR02 set UFLAG='0' where MANDT='100' and BNAME='SAP*';

commit;

This will have unlocked the user, if permitted.

If you do not know the password, you can delete the entry from USR02 for SAP* and the client you want to log in to.

delete from USR02 where MANDT='100' and BNAME='SAP*';

commit;

This will then enable you to log in to the client with the user sap* and the password "pass" (as if you had created a new client for a client copy). You can then recreate the user SAP* and this will writye the entry back into USR02.

Remember that in ERP 6.0, there is a new parameter login/no_automatic_user_sapstar that you must make sure is set to '0'. Otherwise, SAP* with password "pass" will not be enabled automatically.

Hope this helps!

Regards,

Blair Towe

[JPReyes]

unlock it....

Stop asking interview questions!

Regards

Juan