August 2011 ~ HOW TO SAP

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' ...

HOW TO MASS LOCK USER with SQL COMMAND

August 26, 2011 lock user, sql command,

Execute this SQL commandupdate 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: use HRSUPDATE [hrs].[USR02]SET UFLAG = '64'WHERE (UFLAG = '0') AND NOT (BNAME like 'SAP%' OR BNAME =...

HOW TO SAP - SAPCAR all *.car files

August 16, 2011 sapcar,

First search for sapcar.exe. Its usually located at \usr\sap\sid\dvebmgs00\exe Copy the sapcar.exe to the folder where you saved all the *.sar files. Start > Run > cmd > browser to the folder with *.sar files Execute SAPPCAR -xvf ".sar" Without " " it will not work....

HOW TO SAP

Popular Posts

Blog Archive

HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND

HOW TO MASS LOCK USER with SQL COMMAND

HOW TO SAP - SAPCAR all *.car files

HOW TO SAP - command to login to sap system

HOW TO SAP - RUN BDLSS (new)

HOW TO SAP - Change text on main SAPGui logon screen

HOW TO SAP - Tables to find Tcode and Programs

Selamat Berpuasa to all Muslim friends!