9/04/2012

SAP trick Unlock\lock user via SQL command

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='001' and bname='USER';

     UFLAG
----------
       128
Not locked:
SQL> select uflag from sapsr3.usr02 where mandt='023' and bname='USER';

     UFLAG
----------
         0
Unlocking:
SQL> update sapsr3.usr02 set uflag='0' where mandt='001' and bname='USER';

1 row updated.

SQL> commit work;

No comments:

Post a Comment

Popular Posts