FILE 1.txt
| 1 |
INSERT INTO dbo.PL_ROLE_DATA_CONFIG |
|---|---|
| 2 |
( |
| 3 |
ROLE_TYPE, |
| 4 |
BRANCH_ID, |
| 5 |
DEP_ID |
| 6 |
) |
| 7 |
VALUES |
| 8 |
( 'TRADE_USER_VIEW', -- ROLE_TYPE - varchar(100) |
| 9 |
'quyenptt1', -- BRANCH_ID - varchar(100) |
| 10 |
'GOO000000352090' -- DEP_ID - varchar(100) |
| 11 |
) |
| 12 |
INSERT INTO dbo.PL_ROLE_DATA_CONFIG |
| 13 |
( |
| 14 |
ROLE_TYPE, |
| 15 |
BRANCH_ID, |
| 16 |
DEP_ID |
| 17 |
) |
| 18 |
SELECT 'TRADE_USER_VIEW',TLNANME,'GOO000001064587' FROM dbo.TL_USER WHERE SECUR_CODE='DEP000000000062' |
| 19 |
INSERT INTO dbo.PL_ROLE_DATA_CONFIG |
| 20 |
( |
| 21 |
ROLE_TYPE, |
| 22 |
BRANCH_ID, |
| 23 |
DEP_ID |
| 24 |
) |
| 25 |
SELECT 'TRADE_USER_VIEW',TLNANME,'GOO000001064589' FROM dbo.TL_USER WHERE SECUR_CODE='DEP000000000062' |