3 SELECT evergreen.upgrade_deps_block_check('0548', :eg_version); -- dbwells
5 \qecho This redoes the original part 1 of 0547 which did not apply to rel_2_1,
6 \qecho and is being added for the sake of clarity
8 -- delete errant inserts from 0545 (group 4 is NOT the circulation admin group)
9 DELETE FROM permission.grp_perm_map WHERE grp = 4 AND perm IN (
10 SELECT id FROM permission.perm_list
11 WHERE code in ('ABORT_TRANSIT_ON_LOST', 'ABORT_TRANSIT_ON_MISSING')
14 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
16 pgt.id, perm.id, aout.depth, TRUE
18 permission.grp_tree pgt,
19 permission.perm_list perm,
20 actor.org_unit_type aout
22 pgt.name = 'Circulation Administrator' AND
23 aout.name = 'Consortium' AND
25 'ABORT_TRANSIT_ON_LOST',
26 'ABORT_TRANSIT_ON_MISSING'
29 FROM permission.grp_perm_map AS map
32 AND map.perm = perm.id