Lock the user at Database level
Posted by
Admin at
|
Share this post:
|
|
0 Comments
Login to the system database..then run a query to update the USR02 table.
To lock an user.
SQL> UPDATE USR02 SET UFLAG = '64' where BNAME='USERID' AND MANDT='CLIENT'
SQL> COMMIT
To unlock an user use
SQL> UPDATE USR02 SET UFLAG = '0' where BNAME='USERID' AND MANDT='CLIENT'
SQL> COMMIT
Here the different values of uflag have different meaning
UFLAG value
0 ------ Not locked
16 ------ Mystery values
32 ------ Locked by CUA admin
64 ------ Locked by system Administrator
128 ------ Locked due to incorrect logon attempts or too many failed attempts
192 ------ A combination of both. The user is locked by admin and user tries to logon with incorrect passwords and gets locked ( 192 = 64+128)
Keyword: BASIS
Title : Lock the user at Database level
