How to Lock user in SAP?

Go to SU01

Enter the userID to be locked in the user field and click on lock button Then you will see the the following screen if the user is already locked.
click on the unlock button at the bottom left of the window and the user will be unlocked.to lock a user again enter the user id in the user field
and click on lock button and you will see the following screennow press on the lock button to lock the user...you can also lock the user at database level. 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> COMMITTo unlock an user useSQL> UPDATE USR02 SET UFLAG = '0' where BNAME='USERID' AND MANDT='CLIENT'SQL> COMMITHere the different values of uflag have different meaningUFLAG 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)