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
UFLAG
----------
128
Not locked:
SQL> select uflag from sapsr3.usr02 where mandt='023' and bname='USER';
UFLAG
----------
0
UFLAG
----------
0
Unlocking:
SQL> update sapsr3.usr02 set uflag='0' where mandt='001' and bname='USER';
1 row updated.
SQL> commit work;
1 row updated.
SQL> commit work;
No comments:
Post a Comment