3 --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
8 WHERE code IN ('VIEW_BOOKING_RESERVATION', 'VIEW_BOOKING_RESERVATION_ATTR_MAP'))
10 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
11 SELECT grp, perms_to_add.id as perm, depth, grantable
13 permission.grp_perm_map
15 --- Don't add the permissions if they have already been assigned
17 (SELECT DISTINCT grp FROM permission.grp_perm_map
18 INNER JOIN perms_to_add ON perm=perms_to_add.id)
20 --- Anybody who can view resources should also see reservations
24 FROM permission.perm_list
25 WHERE code = 'VIEW_BOOKING_RESOURCE'