SAP Snippets

If you try SAP logon and you get “account locked due to incorrect logins” error you can use one of the following methods to unlock the user:

Use RSUSR200 to list locked users,
then SU01 to unlock the user.

This is not recommended by SAP - use at your own risk
It is useful though if the locked user happens to be DDIC …

• Locate the locked user

select * 
from SAPED1.USR02 
where
    -- UFLAG = 64 -- account locked by administrator
    UFLAG = 128 -- account locked due to incorrect logins ;

• Then update the status flag for the user
  Use an appropriate WHERE clause for the user and test it in a SELECT first!

update SAPED1.USR02
set UFLAG = 0 
where BNAME='DDIC' and UFLAG=128 and MANDT='001'