3 INSERT INTO config.upgrade_log (version) VALUES ('0182'); -- dbs
5 INSERT INTO permission.perm_list (code, description) VALUES
6 ('ADMIN_TRIGGER_CLEANUP', 'Allow a user to create, delete, and update trigger cleanup entries'),
7 ('CREATE_TRIGGER_CLEANUP', 'Allow a user to create trigger cleanup entries'),
8 ('DELETE_TRIGGER_CLEANUP', 'Allow a user to delete trigger cleanup entries'),
9 ('UPDATE_TRIGGER_CLEANUP', 'Allow a user to update trigger cleanup entries'),
10 ('CREATE_TRIGGER_EVENT_DEF', 'Allow a user to create trigger event definitions'),
11 ('DELETE_TRIGGER_EVENT_DEF', 'Allow a user to delete trigger event definitions'),
12 ('UPDATE_TRIGGER_EVENT_DEF', 'Allow a user to update trigger event definitions'),
13 ('VIEW_TRIGGER_EVENT_DEF', 'Allow a user to view trigger event definitions'),
14 ('ADMIN_TRIGGER_HOOK', 'Allow a user to create, update, and delete trigger hooks'),
15 ('CREATE_TRIGGER_HOOK', 'Allow a user to create trigger hooks'),
16 ('DELETE_TRIGGER_HOOK', 'Allow a user to delete trigger hooks'),
17 ('UPDATE_TRIGGER_HOOK', 'Allow a user to update trigger hooks'),
18 ('ADMIN_TRIGGER_REACTOR', 'Allow a user to create, update, and delete trigger reactors'),
19 ('CREATE_TRIGGER_REACTOR', 'Allow a user to create trigger reactors'),
20 ('DELETE_TRIGGER_REACTOR', 'Allow a user to delete trigger reactors'),
21 ('UPDATE_TRIGGER_REACTOR', 'Allow a user to update trigger reactors'),
22 ('ADMIN_TRIGGER_TEMPLATE_OUTPUT', 'Allow a user to delete trigger template output'),
23 ('DELETE_TRIGGER_TEMPLATE_OUTPUT', 'Allow a user to delete trigger template output'),
24 ('ADMIN_TRIGGER_VALIDATOR', 'Allow a user to create, update, and delete trigger validators'),
25 ('CREATE_TRIGGER_VALIDATOR', 'Allow a user to create trigger validators'),
26 ('DELETE_TRIGGER_VALIDATOR', 'Allow a user to delete trigger validators'),
27 ('UPDATE_TRIGGER_VALIDATOR', 'Allow a user to update trigger validators')
30 -- Add trigger administration permissions to the Local System Administrator group
31 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
32 SELECT 10, id, 1, false FROM permission.perm_list
33 WHERE code LIKE 'ADMIN_TRIGGER%'
34 OR code LIKE 'CREATE_TRIGGER%'
35 OR code LIKE 'DELETE_TRIGGER%'
36 OR code LIKE 'UPDATE_TRIGGER%'
38 -- View trigger permissions are required at a consortial level for initial setup
39 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
40 SELECT 10, id, 0, false FROM permission.perm_list WHERE code LIKE 'VIEW_TRIGGER%';