HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND

August 26, 2011   sql command , unlock user

Unlock support team :     
update sid.USR02 set UFLAG=0 where MANDT='110' and BNAME in
('DDIC',
 'SAP*',
 'ALEREMOTE',
 'WF-BATCH',
 'TMSADM',
 'ITOUSER',
 'SAPCPIC',
 'SAPJSF',
 'J2EE_ADMIN',
 'J2EE_GUEST',
 'SAP ADMIN'
)         
          


OR you may unlock all user with
Unlock user :     
update sid.USR02 set UFLAG=0 where MANDT='110'