lock user
- lock user
*Unlock
UPDATE USR02 SET UFLAG = 0
WHERE UFLAG <> 0
*lock
UPDATE USR02 SET UFLAG = 64
WHERE BNAME <> 'DEVKOREA'
AND BNAME <> 'ADMIN',
AND BNAME <> 'DDIC'
AND BNAME <> 'SAP*'
AND BNAME <> 'DEVSEMDG'
tp locksys
tp unlocksys
-tp locksys
-tp unlocksys [@more@]
- lock user
*Unlock
UPDATE USR02 SET UFLAG = 0
WHERE UFLAG <> 0
*lock
UPDATE USR02 SET UFLAG = 64
WHERE BNAME <> 'DEVKOREA'
AND BNAME <> 'ADMIN',
AND BNAME <> 'DDIC'
AND BNAME <> 'SAP*'
AND BNAME <> 'DEVSEMDG'
tp locksys
tp unlocksys
-tp locksys
-tp unlocksys [@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/503782/viewspace-983239/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/503782/viewspace-983239/