User Locked in SAP

Lock user (unlock)

lock - is  a record in the field  uflag, "0" - the user is not locked,
To Unlock - need to switch field  uflag to "0":

Locked

SQL> select uflag from sapsr3.usr02 where mandt='000' and bname='SAP*';

     UFLAG
----------
       128

Not locked:

SQL> select uflag from sapsr3.usr02 where mandt='431' and bname='USERNAME';

     UFLAG
----------
         0

Unlocking:

SQL> update sapsr3.usr02 set uflag='0' where mandt='000' and bname='DDIC';

1 row updated.

SQL> commit work;

UNLOCK your self

update sapr3.usr02 set uflag='0' where mandt='830' and bname='USER'; 

commit work;

RESET PASSWORD PROCESS:

SQL> select bcode, passcode from sapsr3.usr02 where mandt='000' and bname= 'DDIC';

BCODE            PASSCODE

---------------- ----------------------------------------

EF82F150AB6136BF 6BBFC576AC43020521E2206DBC1A0421A43E91C4

SQL> update sapsr3.usr02 set bcode='11FAF9DD879FE537',
passcode='ECB96161D5BDA8E04CE52AC886DEF5CD318869AE' where mandt='000' and bname='DDIC';

IF DATE EXPIRED:

SQL> select PWDCHGDATE from sapr3.usr02 where mandt='830' and bname='USERNAME';

PWDCHGDATE

------------------------

20190227

SQL> update sapr3.usr02 set PWDCHGDATE='20190728' where mandt='830' and bname='USERNAME';

1 row updated.