Project

General

Profile

Download (188 Bytes)

TL_SYS_ROLE_MAPPING.txt

Luc Tran Van, 12/07/2022 10:29 AM

 
1 
UPDATE TL_SYS_ROLE_MAPPING SET EFF_DATE= CONVERT(DATETIME,'1-1-2000',103) ,EXP_DATE=CONVERT(DATETIME,'1-1-2000',103) WHERE TLNAME
2 
IN (SELECT TLNANME FROM TL_USER WHERE RoleName='DISABLE')