INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) VALUES ( 'TRADE_USER_VIEW', -- ROLE_TYPE - varchar(100) 'quyenptt1', -- BRANCH_ID - varchar(100) 'GOO000000352090' -- DEP_ID - varchar(100) ) INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) SELECT 'TRADE_USER_VIEW',TLNANME,'GOO000001064587' FROM dbo.TL_USER WHERE SECUR_CODE='DEP000000000062' INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) SELECT 'TRADE_USER_VIEW',TLNANME,'GOO000001064589' FROM dbo.TL_USER WHERE SECUR_CODE='DEP000000000062'