HOW TO MASS LOCK USER with SQL COMMAND

Execute this SQL command

• update SID.USR02 set UFLAG=64 where MANDT=’110′ and BNAME != ‘SAP*’;    


• Explain : UFLAG=64 means lock


• BNAME !=’SAP*’ means lock everyone except SAP*

Alternately, try the below SQL command:

UPDATE [hrs].[USR02]

SET UFLAG = ’64′

WHERE (UFLAG = ’0′) 

AND NOT (BNAME like ‘SAP%’ OR BNAME = ‘DDIC’ OR BNAME = ‘TMSADM’ 

         OR BNAME like ‘J2EE%’ OR BNAME like ‘SLD%’ OR BNAME = ‘JCO_DATA’

         OR BNAME = ‘BASIS_ADMIN’)

HOW TO SAP – A STEP BY STEP MANUAL GUIDE WITH SCREEN SHOTS

HOW TO MASS LOCK USER with SQL COMMAND

Browse More Articles

Tweet

Written by pd

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.