001.MWCONFIG_INITDB.sql 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423
  1. INSERT INTO MWCONFIG.PRIVILEGE (ID, NAME, TYPE, PATH, PARENT, PRIORITY, STATUS, MODIFIED_BY, TIMESTAMP) VALUES
  2. ('ACTIVITY_LOG', 'ACTIVITY LOG', 'PRIV_TYPE_MENU', './nhLogActivity.do?action=list&clear=true', NULL, 450, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  3. ('ACTIVITY_LOG_LIST', 'Activity Log', 'PRIV_TYPE_MENU', './', 'ACTIVITY_LOG', 452, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  4. ('ACTIVITY_LOG_LIST_EPAYMENT', 'Activity Log List', 'PRIV_TYPE_MENU', './nhLogActivity.do?action=list&clear=true', 'ACTIVITY_LOG_LIST', 452, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  5. ('ADAPTOR_PARAM', 'Adaptor Param', 'PRIV_TYPE_MENU', './adaptorParam.do?action=list&clear=true', 'CONFIGURATION', 97, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  6. ('ADAPTOR_PARAM_CREATE', 'Adaptor Param Create', 'PRIV_TYPE_MENU', './adaptorParam.do?action=create&clear=true', 'ADAPTOR_PARAM', 2, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  7. ('ADAPTOR_PARAM_LIST', 'Adaptor Param List', 'PRIV_TYPE_MENU', './adaptorParam.do?action=list&clear=true', 'ADAPTOR_PARAM', 1, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  8. ('ADAPTOR_PARAM_UPDATE', 'Adaptor Param Update', 'PRIV_TYPE_MENU', './adaptorParam.do?action=edit&clear=true', 'ADAPTOR_PARAM', 3, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  9. ('ADMIN', 'PLUG-IN ADMIN', 'PRIV_TYPE_MENU', './', NULL, 1, 'ACTIVE', 'asrina.sianipar', '2010-07-15 10:17:09.825000'),
  10. ('ADMIN_REPORT', 'Report Admin', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', 'EPAYMENT_ADMIN', 377, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  11. ('ADMIN_REPORT_CREATE', 'Admin Report Create', 'PRIV_TYPE_MENU', './report.do?action=create&clear=true', 'ADMIN_REPORT', 379, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  12. ('ADMIN_REPORT_LIST', 'Admin Report List', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', 'ADMIN_REPORT', 378, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  13. ('ADMIN_REPORT_UPDATE', 'Admin Report Update', 'PRIV_TYPE_MENU', './report.do?action=edit&clear=true', 'ADMIN_REPORT', 380, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  14. ('APP_SETTING', 'Application Setting', 'PRIV_TYPE_MENU', './appSetting.do?action=list&clear=true', 'EPAYMENT_ADMIN', 363, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  15. ('APP_SETTING_CREATE', 'Application Setting Create', 'PRIV_TYPE_MENU', './appSetting.do?action=create&clear=true', 'APP_SETTING', 365, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  16. ('APP_SETTING_LIST', 'Application Setting List', 'PRIV_TYPE_MENU', './appSetting.do?action=list&clear=true', 'APP_SETTING', 364, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  17. ('APP_SETTING_UPDATE', 'Application Setting Update', 'PRIV_TYPE_MENU', './appSetting.do?action=edit&clear=true', 'APP_SETTING', 366, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  18. ('APP_USER', 'Application User', 'PRIV_TYPE_MENU', './appUser.do?action=list&clear=true', 'BILLER', 263, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  19. ('APP_USER_CREATE', 'Application User Create', 'PRIV_TYPE_MENU', './appUser.do?action=create&clear=true', 'APP_USER', 323, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  20. ('APP_USER_LIST', 'Application User List', 'PRIV_TYPE_MENU', './appUser.do?action=list&clear=true', 'APP_USER', 322, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  21. ('APP_USER_UPDATE', 'Application User Update', 'PRIV_TYPE_MENU', './appUser.do?action=edit&clear=true', 'APP_USER', 324, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  22. ('BILLER', 'BILLER', 'PRIV_TYPE_MENU', './', NULL, 250, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  23. ('BILLER_CAT', 'Biller Category', 'PRIV_TYPE_MENU', './billerCategory.do?action=list&clear=true', 'EPAYMENT_ADMIN', 307, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  24. ('BILLER_CAT_CREATE', 'Biller Category Create', 'PRIV_TYPE_MENU', './billerCategory.do?action=create&clear=true', 'BILLER_CAT', 309, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  25. ('BILLER_CAT_LIST', 'Biller Category List', 'PRIV_TYPE_MENU', './billerCategory.do?action=list&clear=true', 'BILLER_CAT', 308, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  26. ('BILLER_CAT_UPDATE', 'Biller Category Update', 'PRIV_TYPE_MENU', './billerCategory.do?action=edit&clear=true', 'BILLER_CAT', 310, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  27. ('BILLER_CONFIG', 'Biller Configuration', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=list&clear=true', 'BILLER', 266, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  28. ('BILLER_CONFIG_CREATE', 'Biller Configuration Create', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=create&clear=true', 'BILLER_CONFIG', 268, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  29. ('BILLER_CONFIG_LIST', 'Biller Configuration List', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=list&clear=true', 'BILLER_CONFIG', 267, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  30. ('BILLER_CONFIG_UPDATE', 'Biller Configuration Update', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=edit&clear=true', 'BILLER_CONFIG', 269, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  31. ('BILLER_DATA', 'Biller Data', 'PRIV_TYPE_MENU', './billerData.do?action=list&clear=true', 'BILLER', 252, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  32. ('BILLER_DATA_CREATE', 'Biller Data Create', 'PRIV_TYPE_MENU', './billerData.do?action=create&clear=true', 'BILLER_DATA', 254, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  33. ('BILLER_DATA_LIST', 'Biller Data List', 'PRIV_TYPE_MENU', './billerData.do?action=list&clear=true', 'BILLER_DATA', 253, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  34. ('BILLER_DATA_UPDATE', 'Biller Data Update', 'PRIV_TYPE_MENU', './billerData.do?action=edit&clear=true', 'BILLER_DATA', 255, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  35. ('BILLER_GROUP_MAINTENANCE', 'Manage Group', 'PRIV_TYPE_MENU', './billerGroup.do?action=edit&clear=true', 'BILLER', 260, 'ACTIVE', 'dame.manalu', '2010-09-21 17:15:11.288000'),
  36. ('CHARGE', 'Charge', 'PRIV_TYPE_MENU', './charge.do?action=list&clear=true', 'CONFIGURATION', 62, 'INACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  37. ('CHARGE_CREATE', 'Charge Create', 'PRIV_TYPE_MENU', './charge.do?action=new&clear=true', 'CHARGE', 64, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  38. ('CHARGE_LIST', 'Charge List', 'PRIV_TYPE_MENU', './charge.do?action=list&clear=true', 'CHARGE', 63, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  39. ('CHARGE_UPDATE', 'Charge Update', 'PRIV_TYPE_MENU', './charge.do?action=edit&clear=true', 'CHARGE', 65, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  40. ('CLIENT', 'Client', 'PRIV_TYPE_MENU', './adaptor.do?action=client_list&clear=true', 'CONFIGURATION', 76, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  41. ('CLIENT_CREATE', 'Client Create', 'PRIV_TYPE_MENU', './adaptor.do?action=client_create&clear=true', 'CLIENT', 78, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  42. ('CLIENT_LIST', 'Client List', 'PRIV_TYPE_MENU', './adaptor.do?action=client_list&clear=true', 'CLIENT', 77, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  43. ('CLIENT_UPDATE', 'Client Update', 'PRIV_TYPE_MENU', './adaptor.do?action=client_edit&clear=true', 'CLIENT', 79, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  44. ('CODEX', 'Codex', 'PRIV_TYPE_MENU', './codex.do?action=list&clear=true', 'CONFIGURATION', 119, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  45. ('CODEX_CREATE', 'Codex Create', 'PRIV_TYPE_MENU', './codex.do?action=create&clear=true', 'CODEX', 121, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  46. ('CODEX_LIST', 'Codex List', 'PRIV_TYPE_MENU', './codex.do?action=list&clear=true', 'CODEX', 120, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  47. ('CODEX_UPDATE', 'Codex Update', 'PRIV_TYPE_MENU', './codex.do?action=edit&clear=true', 'CODEX', 122, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  48. ('CONFIGURATION', 'PLUG-IN CONFIG', 'PRIV_TYPE_MENU', './', NULL, 46, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  49. ('DB_CONN', 'DB Connection', 'PRIV_TYPE_MENU', './dbconn.do?action=list&clear=true', 'CONFIGURATION', 133, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  50. ('DB_CONN_CREATE', 'DB Connection Create', 'PRIV_TYPE_MENU', './dbconn.do?action=create&clear=true', 'DB_CONN', 135, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  51. ('DB_CONN_LIST', 'DB Connection List', 'PRIV_TYPE_MENU', './dbconn.do?action=list&clear=true', 'DB_CONN', 134, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  52. ('DB_CONN_UPDATE', 'DB Connection Update', 'PRIV_TYPE_MENU', './dbconn.do?action=edit&clear=true', 'DB_CONN', 136, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  53. ('DB_QUERY', 'DB Query', 'PRIV_TYPE_MENU', './dbquery.do?action=list&clear=true', 'CONFIGURATION', 147, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  54. ('DB_QUERY_CREATE', 'DB Query Create', 'PRIV_TYPE_MENU', './dbquery.do?action=create&clear=true', 'DB_QUERY', 149, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  55. ('DB_QUERY_LIST', 'DB Query List', 'PRIV_TYPE_MENU', './dbquery.do?action=list&clear=true', 'DB_QUERY', 148, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  56. ('DB_QUERY_UPDATE', 'DB Query Update', 'PRIV_TYPE_MENU', './dbquery.do?action=edit&clear=true', 'DB_QUERY', 150, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  57. ('ENCRYPT', 'Encrypt Password', 'PRIV_TYPE_MENU', './encryptPassword.do?&clear=true&action=encryp', 'CONFIGURATION', 203, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  58. ('EOD', 'EOD', 'PRIV_TYPE_MENU', './', NULL, 420, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  59. ('EOD_CONFIG', 'EOD Config', 'PRIV_TYPE_MENU', './eodConfig.do?action=status&clear=true', 'EOD', 460, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  60. ('EOD_CONFIG_LIST', 'EOD Config List', 'PRIV_TYPE_MENU', './eodConfig.do?action=status&clear=true', 'EOD_CONFIG', 423, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  61. ('EPAYMENT_ADMIN', 'EPAYMENT ADMIN', 'PRIV_TYPE_MENU', './', NULL, 305, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  62. ('EPAY_PRIVILEGE', 'Epayment Privilege', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=list&clear=true', 'EPAYMENT_ADMIN', 349, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  63. ('EPAY_PRIVILEGE_CREATE', 'Epayment Privilege Create', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=create&clear=true', 'EPAY_PRIVILEGE', 351, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  64. ('EPAY_PRIVILEGE_LIST', 'Epayment Privilege List', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=list&clear=true', 'EPAY_PRIVILEGE', 350, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  65. ('EPAY_PRIVILEGE_UPDATE', 'Epayment Privilege Update', 'PRIV_TYPE_MENU', './epayPrivilege.do?action=edit&clear=true', 'EPAY_PRIVILEGE', 352, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  66. ('EPAY_ROLE', 'Epayment Role', 'PRIV_TYPE_MENU', './epayRole.do?action=list&clear=true', 'EPAYMENT_ADMIN', 335, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  67. ('EPAY_ROLE_CREATE', 'Epayment Role Create', 'PRIV_TYPE_MENU', './epayRole.do?action=create&clear=true', 'EPAY_ROLE', 337, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  68. ('EPAY_ROLE_LIST', 'Epayment Role List', 'PRIV_TYPE_MENU', './epayRole.do?action=list&clear=true', 'EPAY_ROLE', 336, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  69. ('EPAY_ROLE_UPDATE', 'Epayment Role Update', 'PRIV_TYPE_MENU', './epayRole.do?action=edit&clear=true', 'EPAY_ROLE', 338, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  70. ('HOST', 'Host', 'PRIV_TYPE_MENU', './host.do?action=list&clear=true', 'CONFIGURATION', 161, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  71. ('HOST_CREATE', 'Host Create', 'PRIV_TYPE_MENU', './host.do?action=create&clear=true', 'HOST', 163, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  72. ('HOST_LIST', 'Host List', 'PRIV_TYPE_MENU', './host.do?action=list&clear=true', 'HOST', 162, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  73. ('HOST_UPDATE', 'Host Update', 'PRIV_TYPE_MENU', './host.do?action=edit&clear=true', 'HOST', 164, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  74. ('LOG_MESSAGE', 'LOG MESSAGE', 'PRIV_TYPE_MENU', './dlog.do?action=list&clear=true', NULL, 32, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  75. ('LOG_MESSAGE_LIST', 'Log Message', 'PRIV_TYPE_MENU', './dlog.do?action=list&clear=true', 'LOG_MESSAGE', 34, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  76. ('LOG_MESSAGE_LIST_MDW', 'Log Message List', 'PRIV_TYPE_MENU', './dlog.do?action=list&clear=true', 'LOG_MESSAGE_LIST', 35, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  77. ('MAPPING', 'Mapping', 'PRIV_TYPE_MENU', './mapping.do?action=list&clear=true', 'CONFIGURATION', 189, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  78. ('MAPPING_CREATE', 'Mapping Create', 'PRIV_TYPE_MENU', './mapping.do?action=create&clear=true', 'MAPPING', 191, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  79. ('MAPPING_LIST', 'Mapping List', 'PRIV_TYPE_MENU', './mapping.do?action=list&clear=true', 'MAPPING', 190, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  80. ('MAPPING_UPDATE', 'Mapping Update', 'PRIV_TYPE_MENU', './mapping.do?action=edit&clear=true', 'MAPPING', 192, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  81. ('PARSER', 'Parser', 'PRIV_TYPE_MENU', './parser.do?action=list&clear=true', 'CONFIGURATION', 105, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  82. ('PARSER_CREATE', 'Parser Create', 'PRIV_TYPE_MENU', './parser.do?action=create&clear=true', 'PARSER', 107, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  83. ('PARSER_LIST', 'Parser List', 'PRIV_TYPE_MENU', './parser.do?action=list&clear=true', 'PARSER', 106, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  84. ('PARSER_UPDATE', 'Parser Update', 'PRIV_TYPE_MENU', './parser.do?action=edit&clear=true', 'PARSER', 108, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  85. ('PRIVILEGE', 'Privilege', 'PRIV_TYPE_MENU', './privilege.do?action=list&clear=true', 'ADMIN', 26, 'ACTIVE', 'asrina.sianipar', '2010-07-15 10:18:55.197000'),
  86. ('PRIVILEGE_CREATE', 'Privilege Create', 'PRIV_TYPE_MENU', './privilege.do?action=create&clear=true', 'PRIVILEGE', 28, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  87. ('PRIVILEGE_LIST', 'Privilege List', 'PRIV_TYPE_MENU', './privilege.do?action=list&clear=true', 'PRIVILEGE', 27, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  88. ('PRIVILEGE_UPDATE', 'Privilege Update', 'PRIV_TYPE_MENU', './privilege.do?action=edit&clear=true', 'PRIVILEGE', 29, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  89. ('ROLE', 'Role', 'PRIV_TYPE_MENU', './role.do?action=list&clear=true', 'ADMIN', 12, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  90. ('ROLE_CREATE', 'Role Create', 'PRIV_TYPE_MENU', './role.do?action=create&clear=true', 'ROLE', 14, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  91. ('ROLE_LIST', 'Role List', 'PRIV_TYPE_MENU', './role.do?action=list&clear=true', 'ROLE', 13, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  92. ('ROLE_UPDATE', 'Role Update', 'PRIV_TYPE_MENU', './role.do?action=edit&clear=true', 'ROLE', 15, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  93. ('ROUTING_TABLE', 'Routing Table', 'PRIV_TYPE_MENU', './routingTable.do?action=list&clear=true', 'CONFIGURATION', 48, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  94. ('ROUTING_TABLE_CREATE', 'Routing Table Create', 'PRIV_TYPE_MENU', './routingTable.do?action=create&clear=true', 'ROUTING_TABLE', 50, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  95. ('ROUTING_TABLE_LIST', 'Routing Table List', 'PRIV_TYPE_MENU', './routingTable.do?action=list&clear=true', 'ROUTING_TABLE', 49, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  96. ('ROUTING_TABLE_UPDATE', 'Routing Table Update', 'PRIV_TYPE_MENU', './routingTable.do?action=edit&clear=true', 'ROUTING_TABLE', 51, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  97. ('RPG_CALL', 'RPG Call', 'PRIV_TYPE_MENU', './rpgCall.do?action=list&clear=true', 'CONFIGURATION', 175, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  98. ('RPG_CALL_CREATE', 'RPG Call Create', 'PRIV_TYPE_MENU', './rpgCall.do?action=create&clear=true', 'RPG_CALL', 177, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  99. ('RPG_CALL_LIST', 'RPG Call List', 'PRIV_TYPE_MENU', './rpgCall.do?action=list&clear=true', 'RPG_CALL', 176, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  100. ('RPG_CALL_UPDATE', 'RPG Call Update', 'PRIV_TYPE_MENU', './rpgCall.do?action=edit&clear=true', 'RPG_CALL', 178, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  101. ('SEP_ACTIVITY_LOG', 'Separator Activity Log', 'PRIV_TYPE_MENU', './', 'ACTIVITY_LOG', 451, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  102. ('SEP_ACTIVITY_LOG_LIST', 'Separator Activity Log List', 'PRIV_TYPE_MENU', './', 'ACTIVITY_LOG', 417, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  103. ('SEP_ADMIN', 'Separator Admin', 'PRIV_TYPE_MENU', './', 'ADMIN', 11, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  104. ('SEP_ADMIN_PLUGIN_PRIVILEGE', 'Separator Admin Plugin privilege', 'PRIV_TYPE_MENU', './', 'ADMIN', 31, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  105. ('SEP_ADMIN_PLUGIN_ROLE', 'Separator Admin Plugin role', 'PRIV_TYPE_MENU', './', 'ADMIN', 25, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  106. ('SEP_ADMIN_REPORT', 'Separator Administration Report', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 390, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  107. ('SEP_APP_SETTING', 'Separator Application Setting', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 376, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  108. ('SEP_APP_USER', 'Separator Application User', 'PRIV_TYPE_MENU', './', 'BILLER', 264, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  109. ('SEP_BILLER', 'Separator Biller', 'PRIV_TYPE_MENU', './', 'BILLER', 251, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  110. ('SEP_BILLER_CAT', 'Separator Biller Category', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 320, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  111. ('SEP_BILLER_CONFIG', 'Separator Biller Config', 'PRIV_TYPE_MENU', './', 'BILLER', 279, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  112. ('SEP_BILLER_DATA', 'Separator Biller Data', 'PRIV_TYPE_MENU', './', 'BILLER', 256, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  113. ('SEP_BILLER_GROUP_MAINTENANCE', 'Separator Biller Group Maintanance', 'PRIV_TYPE_MENU', './', 'BILLER', 261, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  114. ('SEP_BILLER_SYNC_MON', 'Separator Biller Sync Mon', 'PRIV_TYPE_MENU', './', 'BILLER', 290, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  115. ('SEP_CONFIGURATION', 'Separator Configuration', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 47, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  116. ('SEP_CONFIGURATION_ADAPTOR', 'Separator Adaptor', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 95, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  117. ('SEP_CONFIGURATION_ADAPTOR_PARAM', 'Separator Adaptor Param', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 98, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  118. ('SEP_CONFIGURATION_CHARGE', 'Separator Charge', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 75, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  119. ('SEP_CONFIGURATION_CLIENT', 'Separator Client', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 89, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  120. ('SEP_CONFIGURATION_CODEX', 'Separator Codex', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 132, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  121. ('SEP_CONFIGURATION_DB_CONN', 'Separator Db Conn', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 146, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  122. ('SEP_CONFIGURATION_DB_QUERY', 'Separator Db Query', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 160, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  123. ('SEP_CONFIGURATION_ENCRYPT', 'Separator Mapping', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 224, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  124. ('SEP_CONFIGURATION_HOST', 'Separator Host', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 174, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  125. ('SEP_CONFIGURATION_MAPPING', 'Separator Mapping', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 202, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  126. ('SEP_CONFIGURATION_PARSER', 'Separator Parser', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 118, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  127. ('SEP_CONFIGURATION_ROUTING_TABLE', 'Separator Routing Table', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 61, 'INACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  128. ('SEP_CONFIGURATION_RPG_CALL', 'Separator Host', 'PRIV_TYPE_MENU', './', 'CONFIGURATION', 188, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  129. ('SEP_EOD', 'Separator Eod', 'PRIV_TYPE_MENU', './', 'EOD', 421, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  130. ('SEP_EOD_CONFIG_LIST', 'Separator Eod Config List', 'PRIV_TYPE_MENU', './', 'EOD', 461, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  131. ('SEP_EPAYMENT_ADMIN', 'Separator Epayment Admin', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 306, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  132. ('SEP_EPAY_PRIVILEGE', 'Separator Epayment Privilege', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 362, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  133. ('SEP_EPAY_ROLE', 'Separator Epayment Role', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 348, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  134. ('SEP_LOG_MESSAGE', 'Separator Log Message', 'PRIV_TYPE_MENU', './', 'LOG_MESSAGE', 33, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  135. ('SEP_LOG_MESSAGE_LIST', 'Separator Admin Log Message', 'PRIV_TYPE_MENU', './', 'LOG_MESSAGE', 45, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  136. ('SEP_REPORT', 'Separator Report', 'PRIV_TYPE_MENU', './', 'VIEW_REPORT', 292, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  137. ('SEP_REPORT_VIEW_LIST', 'Separator Report View List', 'PRIV_TYPE_MENU', './', 'VIEW_REPORT', 304, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  138. ('SEP_SERVER_CONFIG', 'Separator Server Config', 'PRIV_TYPE_MENU', './', 'EPAYMENT_ADMIN', 401, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  139. ('SERVER_CONFIG', 'Sync Server Status', 'PRIV_TYPE_MENU', './nhServerConfig.do?action=list&clear=true', 'EPAYMENT_ADMIN', 400, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  140. ('SERVER_PORT', 'Server Port', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_list&clear=true', 'CONFIGURATION', 90, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  141. ('SERVER_PORT_CREATE', 'Server Port Create', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_create&clear=true', 'SERVER_PORT', 92, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  142. ('SERVER_PORT_LIST', 'Server Port List', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_list&clear=true', 'SERVER_PORT', 91, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  143. ('SERVER_PORT_UPDATE', 'Server Port Update', 'PRIV_TYPE_MENU', './adaptor.do?action=serverPort_edit&clear=true', 'SERVER_PORT', 93, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  144. ('SYNC_MON', 'Synchronize Monitoring', 'PRIV_TYPE_MENU', './nhBillerConfig.do?action=list_monitoring&clear=true', 'BILLER', 280, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  145. ('VIEW_REPORT', 'REPORT', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', NULL, 291, 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  146. ('VIEW_REPORT_LIST', 'Epayment Report', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', 'VIEW_REPORT', 293, 'INACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  147. ('VIEW_REPORT_LIST_EPAYMENT', 'Epayment Report List ', 'PRIV_TYPE_MENU', './report.do?action=list&clear=true', 'VIEW_REPORT_LIST', 294, 'INACTIVE', CURRENT USER, CURRENT TIMESTAMP);
  148. INSERT INTO MWCONFIG."ROLE" (ID, NAME, STATUS, MODIFIED_BY, "TIMESTAMP") VALUES
  149. ('Hanoman workgroup', 'Naaaama', 'INACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  150. ('epaymentadmin', 'System Administrator Epayment', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  151. ('epaymentstaff', 'Staff Epayment', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  152. ('mdwadmin', 'System Administrator Middleware', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  153. ('mdwstaff', 'Staff Middleware', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP),
  154. ('wsadmin', 'Staff Middleware', 'ACTIVE', CURRENT USER, CURRENT TIMESTAMP);
  155. INSERT INTO MWCONFIG.ROLE_PRIVILEGE (ROLE, PRIVILEGE) VALUES
  156. ('Hanoman workgroup', 'BILLER_CAT'),
  157. ('epaymentadmin', 'ACTIVITY_LOG'),
  158. ('epaymentadmin', 'ACTIVITY_LOG_LIST'),
  159. ('epaymentadmin', 'ACTIVITY_LOG_LIST_EPAYMENT'),
  160. ('epaymentadmin', 'ADMIN_REPORT'),
  161. ('epaymentadmin', 'ADMIN_REPORT_CREATE'),
  162. ('epaymentadmin', 'ADMIN_REPORT_LIST'),
  163. ('epaymentadmin', 'ADMIN_REPORT_UPDATE'),
  164. ('epaymentadmin', 'APP_SETTING'),
  165. ('epaymentadmin', 'APP_SETTING_CREATE'),
  166. ('epaymentadmin', 'APP_SETTING_LIST'),
  167. ('epaymentadmin', 'APP_SETTING_UPDATE'),
  168. ('epaymentadmin', 'APP_USER'),
  169. ('epaymentadmin', 'APP_USER_CREATE'),
  170. ('epaymentadmin', 'APP_USER_LIST'),
  171. ('epaymentadmin', 'APP_USER_UPDATE'),
  172. ('epaymentadmin', 'BILLER'),
  173. ('epaymentadmin', 'BILLER_CAT'),
  174. ('epaymentadmin', 'BILLER_CAT_CREATE'),
  175. ('epaymentadmin', 'BILLER_CAT_LIST'),
  176. ('epaymentadmin', 'BILLER_CAT_UPDATE'),
  177. ('epaymentadmin', 'BILLER_CONFIG'),
  178. ('epaymentadmin', 'BILLER_CONFIG_CREATE'),
  179. ('epaymentadmin', 'BILLER_CONFIG_LIST'),
  180. ('epaymentadmin', 'BILLER_CONFIG_UPDATE'),
  181. ('epaymentadmin', 'BILLER_DATA'),
  182. ('epaymentadmin', 'BILLER_DATA_CREATE'),
  183. ('epaymentadmin', 'BILLER_DATA_LIST'),
  184. ('epaymentadmin', 'BILLER_DATA_UPDATE'),
  185. ('epaymentadmin', 'BILLER_GROUP_MAINTENANCE'),
  186. ('epaymentadmin', 'EPAYMENT_ADMIN'),
  187. ('epaymentadmin', 'EPAY_PRIVILEGE'),
  188. ('epaymentadmin', 'EPAY_PRIVILEGE_CREATE'),
  189. ('epaymentadmin', 'EPAY_PRIVILEGE_LIST'),
  190. ('epaymentadmin', 'EPAY_PRIVILEGE_UPDATE'),
  191. ('epaymentadmin', 'EPAY_ROLE'),
  192. ('epaymentadmin', 'EPAY_ROLE_CREATE'),
  193. ('epaymentadmin', 'EPAY_ROLE_LIST'),
  194. ('epaymentadmin', 'EPAY_ROLE_UPDATE'),
  195. ('epaymentadmin', 'SEP_ACTIVITY_LOG'),
  196. ('epaymentadmin', 'SEP_ACTIVITY_LOG_LIST'),
  197. ('epaymentadmin', 'SEP_ADMIN_REPORT'),
  198. ('epaymentadmin', 'SEP_APP_SETTING'),
  199. ('epaymentadmin', 'SEP_APP_USER'),
  200. ('epaymentadmin', 'SEP_BILLER'),
  201. ('epaymentadmin', 'SEP_BILLER_CAT'),
  202. ('epaymentadmin', 'SEP_BILLER_CONFIG'),
  203. ('epaymentadmin', 'SEP_BILLER_DATA'),
  204. ('epaymentadmin', 'SEP_BILLER_GROUP_MAINTENANCE'),
  205. ('epaymentadmin', 'SEP_BILLER_SYNC_MON'),
  206. ('epaymentadmin', 'SEP_EPAYMENT_ADMIN'),
  207. ('epaymentadmin', 'SEP_EPAY_PRIVILEGE'),
  208. ('epaymentadmin', 'SEP_EPAY_ROLE'),
  209. ('epaymentadmin', 'SEP_REPORT'),
  210. ('epaymentadmin', 'SEP_REPORT_VIEW_LIST'),
  211. ('epaymentadmin', 'SEP_SERVER_CONFIG'),
  212. ('epaymentadmin', 'SERVER_CONFIG'),
  213. ('epaymentadmin', 'SYNC_MON'),
  214. ('epaymentadmin', 'VIEW_REPORT_LIST'),
  215. ('epaymentadmin', 'VIEW_REPORT_LIST_EPAYMENT'),
  216. ('mdwadmin', 'ADAPTOR_PARAM'),
  217. ('mdwadmin', 'ADAPTOR_PARAM_CREATE'),
  218. ('mdwadmin', 'ADAPTOR_PARAM_LIST'),
  219. ('mdwadmin', 'ADAPTOR_PARAM_UPDATE'),
  220. ('mdwadmin', 'ADMIN'),
  221. ('mdwadmin', 'CHARGE'),
  222. ('mdwadmin', 'CHARGE_CREATE'),
  223. ('mdwadmin', 'CHARGE_LIST'),
  224. ('mdwadmin', 'CHARGE_UPDATE'),
  225. ('mdwadmin', 'CLIENT'),
  226. ('mdwadmin', 'CLIENT_CREATE'),
  227. ('mdwadmin', 'CLIENT_LIST'),
  228. ('mdwadmin', 'CLIENT_UPDATE'),
  229. ('mdwadmin', 'CODEX'),
  230. ('mdwadmin', 'CODEX_CREATE'),
  231. ('mdwadmin', 'CODEX_LIST'),
  232. ('mdwadmin', 'CODEX_UPDATE'),
  233. ('mdwadmin', 'CONFIGURATION'),
  234. ('mdwadmin', 'DB_CONN'),
  235. ('mdwadmin', 'DB_CONN_CREATE'),
  236. ('mdwadmin', 'DB_CONN_LIST'),
  237. ('mdwadmin', 'DB_CONN_UPDATE'),
  238. ('mdwadmin', 'DB_QUERY'),
  239. ('mdwadmin', 'DB_QUERY_CREATE'),
  240. ('mdwadmin', 'DB_QUERY_LIST'),
  241. ('mdwadmin', 'DB_QUERY_UPDATE'),
  242. ('mdwadmin', 'ENCRYPT'),
  243. ('mdwadmin', 'EOD'),
  244. ('mdwadmin', 'EOD_CONFIG'),
  245. ('mdwadmin', 'EOD_CONFIG_LIST'),
  246. ('mdwadmin', 'HOST'),
  247. ('mdwadmin', 'HOST_CREATE'),
  248. ('mdwadmin', 'HOST_LIST'),
  249. ('mdwadmin', 'HOST_UPDATE'),
  250. ('mdwadmin', 'LOG_MESSAGE'),
  251. ('mdwadmin', 'LOG_MESSAGE_LIST'),
  252. ('mdwadmin', 'LOG_MESSAGE_LIST_MDW'),
  253. ('mdwadmin', 'MAPPING'),
  254. ('mdwadmin', 'MAPPING_CREATE'),
  255. ('mdwadmin', 'MAPPING_LIST'),
  256. ('mdwadmin', 'MAPPING_UPDATE'),
  257. ('mdwadmin', 'PARSER'),
  258. ('mdwadmin', 'PARSER_CREATE'),
  259. ('mdwadmin', 'PARSER_LIST'),
  260. ('mdwadmin', 'PARSER_UPDATE'),
  261. ('mdwadmin', 'PRIVILEGE'),
  262. ('mdwadmin', 'PRIVILEGE_CREATE'),
  263. ('mdwadmin', 'PRIVILEGE_LIST'),
  264. ('mdwadmin', 'PRIVILEGE_UPDATE'),
  265. ('mdwadmin', 'ROLE'),
  266. ('mdwadmin', 'ROLE_CREATE'),
  267. ('mdwadmin', 'ROLE_LIST'),
  268. ('mdwadmin', 'ROLE_UPDATE'),
  269. ('mdwadmin', 'ROUTING_TABLE'),
  270. ('mdwadmin', 'ROUTING_TABLE_CREATE'),
  271. ('mdwadmin', 'ROUTING_TABLE_LIST'),
  272. ('mdwadmin', 'ROUTING_TABLE_UPDATE'),
  273. ('mdwadmin', 'RPG_CALL'),
  274. ('mdwadmin', 'RPG_CALL_CREATE'),
  275. ('mdwadmin', 'RPG_CALL_LIST'),
  276. ('mdwadmin', 'RPG_CALL_UPDATE'),
  277. ('mdwadmin', 'SEP_ADMIN'),
  278. ('mdwadmin', 'SEP_ADMIN_PLUGIN_PRIVILEGE'),
  279. ('mdwadmin', 'SEP_ADMIN_PLUGIN_ROLE'),
  280. ('mdwadmin', 'SEP_CONFIGURATION'),
  281. ('mdwadmin', 'SEP_CONFIGURATION_ADAPTOR'),
  282. ('mdwadmin', 'SEP_CONFIGURATION_ADAPTOR_PARAM'),
  283. ('mdwadmin', 'SEP_CONFIGURATION_CHARGE'),
  284. ('mdwadmin', 'SEP_CONFIGURATION_CLIENT'),
  285. ('mdwadmin', 'SEP_CONFIGURATION_CODEX'),
  286. ('mdwadmin', 'SEP_CONFIGURATION_DB_CONN'),
  287. ('mdwadmin', 'SEP_CONFIGURATION_DB_QUERY'),
  288. ('mdwadmin', 'SEP_CONFIGURATION_ENCRYPT'),
  289. ('mdwadmin', 'SEP_CONFIGURATION_HOST'),
  290. ('mdwadmin', 'SEP_CONFIGURATION_MAPPING'),
  291. ('mdwadmin', 'SEP_CONFIGURATION_PARSER'),
  292. ('mdwadmin', 'SEP_CONFIGURATION_ROUTING_TABLE'),
  293. ('mdwadmin', 'SEP_CONFIGURATION_RPG_CALL'),
  294. ('mdwadmin', 'SEP_EOD'),
  295. ('mdwadmin', 'SEP_EOD_CONFIG_LIST'),
  296. ('mdwadmin', 'SEP_LOG_MESSAGE'),
  297. ('mdwadmin', 'SEP_LOG_MESSAGE_LIST'),
  298. ('mdwadmin', 'SERVER_PORT'),
  299. ('mdwadmin', 'SERVER_PORT_CREATE'),
  300. ('mdwadmin', 'SERVER_PORT_LIST'),
  301. ('mdwadmin', 'SERVER_PORT_UPDATE'),
  302. ('mdwstaff', 'ADMIN'),
  303. ('mdwstaff', 'CHARGE'),
  304. ('mdwstaff', 'CHARGE_LIST'),
  305. ('mdwstaff', 'CLIENT'),
  306. ('mdwstaff', 'CLIENT_LIST'),
  307. ('mdwstaff', 'CODEX'),
  308. ('mdwstaff', 'CODEX_LIST'),
  309. ('mdwstaff', 'CONFIGURATION'),
  310. ('mdwstaff', 'DB_CONN'),
  311. ('mdwstaff', 'DB_CONN_LIST'),
  312. ('mdwstaff', 'DB_QUERY'),
  313. ('mdwstaff', 'DB_QUERY_LIST'),
  314. ('mdwstaff', 'HOST'),
  315. ('mdwstaff', 'HOST_LIST'),
  316. ('mdwstaff', 'LOG_MESSAGE'),
  317. ('mdwstaff', 'LOG_MESSAGE_LIST'),
  318. ('mdwstaff', 'LOG_MESSAGE_LIST_MDW'),
  319. ('mdwstaff', 'MAPPING'),
  320. ('mdwstaff', 'MAPPING_LIST'),
  321. ('mdwstaff', 'PARSER'),
  322. ('mdwstaff', 'PARSER_LIST'),
  323. ('mdwstaff', 'PRIVILEGE'),
  324. ('mdwstaff', 'PRIVILEGE_LIST'),
  325. ('mdwstaff', 'ROLE'),
  326. ('mdwstaff', 'ROLE_LIST'),
  327. ('mdwstaff', 'ROUTING_TABLE'),
  328. ('mdwstaff', 'ROUTING_TABLE_LIST'),
  329. ('mdwstaff', 'RPG_CALL'),
  330. ('mdwstaff', 'RPG_CALL_LIST'),
  331. ('mdwstaff', 'SEP_ADMIN'),
  332. ('mdwstaff', 'SEP_CONFIGURATION'),
  333. ('mdwstaff', 'SEP_LOG_MESSAGE'),
  334. ('mdwstaff', 'SERVER_PORT'),
  335. ('mdwstaff', 'SERVER_PORT_LIST'),
  336. ('wsadmin', 'ADAPTOR_PARAM'),
  337. ('wsadmin', 'ADAPTOR_PARAM_CREATE'),
  338. ('wsadmin', 'ADAPTOR_PARAM_LIST'),
  339. ('wsadmin', 'ADAPTOR_PARAM_UPDATE'),
  340. ('wsadmin', 'ADMIN'),
  341. ('wsadmin', 'CHARGE'),
  342. ('wsadmin', 'CHARGE_CREATE'),
  343. ('wsadmin', 'CHARGE_LIST'),
  344. ('wsadmin', 'CHARGE_UPDATE'),
  345. ('wsadmin', 'CLIENT'),
  346. ('wsadmin', 'CLIENT_CREATE'),
  347. ('wsadmin', 'CLIENT_LIST'),
  348. ('wsadmin', 'CLIENT_UPDATE'),
  349. ('wsadmin', 'CODEX'),
  350. ('wsadmin', 'CODEX_CREATE'),
  351. ('wsadmin', 'CODEX_LIST'),
  352. ('wsadmin', 'CODEX_UPDATE'),
  353. ('wsadmin', 'CONFIGURATION'),
  354. ('wsadmin', 'DB_CONN'),
  355. ('wsadmin', 'DB_CONN_CREATE'),
  356. ('wsadmin', 'DB_CONN_LIST'),
  357. ('wsadmin', 'DB_CONN_UPDATE'),
  358. ('wsadmin', 'DB_QUERY'),
  359. ('wsadmin', 'DB_QUERY_CREATE'),
  360. ('wsadmin', 'DB_QUERY_LIST'),
  361. ('wsadmin', 'DB_QUERY_UPDATE'),
  362. ('wsadmin', 'ENCRYPT'),
  363. ('wsadmin', 'EOD'),
  364. ('wsadmin', 'EOD_CONFIG'),
  365. ('wsadmin', 'EOD_CONFIG_LIST'),
  366. ('wsadmin', 'HOST'),
  367. ('wsadmin', 'HOST_CREATE'),
  368. ('wsadmin', 'HOST_LIST'),
  369. ('wsadmin', 'HOST_UPDATE'),
  370. ('wsadmin', 'LOG_MESSAGE'),
  371. ('wsadmin', 'LOG_MESSAGE_LIST'),
  372. ('wsadmin', 'LOG_MESSAGE_LIST_MDW'),
  373. ('wsadmin', 'MAPPING'),
  374. ('wsadmin', 'MAPPING_CREATE'),
  375. ('wsadmin', 'MAPPING_LIST'),
  376. ('wsadmin', 'MAPPING_UPDATE'),
  377. ('wsadmin', 'PARSER'),
  378. ('wsadmin', 'PARSER_CREATE'),
  379. ('wsadmin', 'PARSER_LIST'),
  380. ('wsadmin', 'PARSER_UPDATE'),
  381. ('wsadmin', 'PRIVILEGE'),
  382. ('wsadmin', 'PRIVILEGE_CREATE'),
  383. ('wsadmin', 'PRIVILEGE_LIST'),
  384. ('wsadmin', 'PRIVILEGE_UPDATE'),
  385. ('wsadmin', 'ROLE'),
  386. ('wsadmin', 'ROLE_CREATE'),
  387. ('wsadmin', 'ROLE_LIST'),
  388. ('wsadmin', 'ROLE_UPDATE'),
  389. ('wsadmin', 'ROUTING_TABLE'),
  390. ('wsadmin', 'ROUTING_TABLE_CREATE'),
  391. ('wsadmin', 'ROUTING_TABLE_LIST'),
  392. ('wsadmin', 'ROUTING_TABLE_UPDATE'),
  393. ('wsadmin', 'RPG_CALL'),
  394. ('wsadmin', 'RPG_CALL_CREATE'),
  395. ('wsadmin', 'RPG_CALL_LIST'),
  396. ('wsadmin', 'RPG_CALL_UPDATE'),
  397. ('wsadmin', 'SEP_ADMIN'),
  398. ('wsadmin', 'SEP_ADMIN_PLUGIN_PRIVILEGE'),
  399. ('wsadmin', 'SEP_ADMIN_PLUGIN_ROLE'),
  400. ('wsadmin', 'SEP_CONFIGURATION'),
  401. ('wsadmin', 'SEP_CONFIGURATION_ADAPTOR'),
  402. ('wsadmin', 'SEP_CONFIGURATION_ADAPTOR_PARAM'),
  403. ('wsadmin', 'SEP_CONFIGURATION_CHARGE'),
  404. ('wsadmin', 'SEP_CONFIGURATION_CLIENT'),
  405. ('wsadmin', 'SEP_CONFIGURATION_CODEX'),
  406. ('wsadmin', 'SEP_CONFIGURATION_DB_CONN'),
  407. ('wsadmin', 'SEP_CONFIGURATION_DB_QUERY'),
  408. ('wsadmin', 'SEP_CONFIGURATION_ENCRYPT'),
  409. ('wsadmin', 'SEP_CONFIGURATION_HOST'),
  410. ('wsadmin', 'SEP_CONFIGURATION_MAPPING'),
  411. ('wsadmin', 'SEP_CONFIGURATION_PARSER'),
  412. ('wsadmin', 'SEP_CONFIGURATION_ROUTING_TABLE'),
  413. ('wsadmin', 'SEP_CONFIGURATION_RPG_CALL'),
  414. ('wsadmin', 'SEP_EOD'),
  415. ('wsadmin', 'SEP_EOD_CONFIG_LIST'),
  416. ('wsadmin', 'SEP_LOG_MESSAGE'),
  417. ('wsadmin', 'SEP_LOG_MESSAGE_LIST'),
  418. ('wsadmin', 'SERVER_PORT'),
  419. ('wsadmin', 'SERVER_PORT_CREATE'),
  420. ('wsadmin', 'SERVER_PORT_LIST'),
  421. ('wsadmin', 'SERVER_PORT_UPDATE');