topic Re: How to unlock SAP* user in Application Development and Automation Discussions

How to unlock SAP* user

Former Member — Wed, 04 Apr 2007 10:54:09 GMT

Hi,

SAP* and DDIC users are locked in 000 client.

I have tried to unlocked them in SQL but it doesn`t work. Have you any idea what`s wrong?

Barbora

Re: How to unlock SAP* user

Former Member — Wed, 04 Apr 2007 10:56:58 GMT

Goto SU01

Give the username to be unlocked

Click on Lock button in application toolbar

then in the pop up unlock that

Re: How to unlock SAP* user

Former Member — Wed, 04 Apr 2007 11:11:07 GMT

Goto SU01 tcode.

Enter the user which is locked.

Now select USERS in menu bar click LOCK now a popup will appear in tht click unlock icon.

A message will be displayed tht user is unlocked.

Re: How to unlock SAP* user

former_member189631 — Wed, 04 Apr 2007 11:16:48 GMT

Hi Barbora,

Follow these steps,

SU01 --> Enter the locked userName --> Just press the Lock symbol

Regards,

Ramganesan K.

Re: How to unlock SAP* user

Former Member — Wed, 04 Apr 2007 12:14:34 GMT

Well, the problem is, that I cannot log on to the system 000 clien, otherwise I would use SU01 transaction.

I have only SAP* and DDIC in client 000 and both of them are locked.

It's why I tried to unlock the users in SQL, but it doesn`t work for some reason.

I changed UFLAG by command:

<i>SQL> update <owner>.usr02 set uflag='0' where bname='<USERID>' and mandt=<client>;

But when I tried to log on the system I am still getting error that user is locked!

Barbora

Re: How to unlock SAP* user

Former Member — Wed, 04 Apr 2007 13:01:30 GMT

I have just deleted SAP* from 000 client and tried to log on with password "pass". But unfortunately I am still getting error that user SAP* is locked, although login/no_automatic_user_sapstar parametr is set to value "0".

Barbora

Re: How to unlock SAP* user

Former Member — Tue, 29 Jun 2010 19:19:48 GMT

Which database you are using.

Re: How to unlock SAP* user

former_member122211 — Fri, 20 May 2011 20:10:55 GMT


Well, the problem is, that I cannot log on to the system 000 clien, otherwise I would use SU01 transaction. 
> I have only SAP* and DDIC in client 000 and both of them are locked.
> It's why I tried to unlock the users in SQL, but it doesn`t work for some reason.
> I changed UFLAG by command:
> <i>SQL> update <owner>.usr02 set uflag='0' where bname='<USERID>' and mandt=<client>;
> But when I tried to log on the system I am still getting error that user is locked!
> 
> Barbora

I think you missed something:

COMMIT;

Re: How to unlock SAP* user

Former Member — Sun, 07 Oct 2012 16:23:23 GMT

Unlock user by using

SU01, EWZ5, or Program BAPI_USER_UNLOCK

Reference: http://www.findsap.com/blog/2012/how-to-unlock-user-in-sap-by-using-tcode-other-than-su01

Re: How to unlock SAP* user

Former Member — Mon, 04 Apr 2016 05:53:28 GMT

This message was moderated.

Re: How to unlock SAP* user

Amit_ggn — Mon, 27 Jan 2025 12:01:41 GMT

Thank You