|
1
|
DELETE FROM PL_ROLE_DATA_CONFIG
|
|
2
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'PL_MASTER',N'DV0001',N'DEP000000000023')
|
|
3
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000059',N'DV0001')
|
|
4
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000063',N'DV0001')
|
|
5
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000001',N'DV0001')
|
|
6
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000002',N'DV0001')
|
|
7
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000005',N'DV0001')
|
|
8
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000008',N'DV0001')
|
|
9
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000011',N'DV0001')
|
|
10
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000016',N'DV0001')
|
|
11
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000021',N'DV0001')
|
|
12
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000024',N'DV0001')
|
|
13
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000030',N'DV0001')
|
|
14
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000038',N'DV0001')
|
|
15
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000045',N'DV0001')
|
|
16
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000049',N'DV0001')
|
|
17
|
INSERT INTO [PL_ROLE_DATA_CONFIG] ([ROLE_TYPE],[BRANCH_ID],[DEP_ID])VALUES(N'TRADE_USER_ALL',N'DEP000000000804',N'DV0001')
|