3 INSERT INTO permission.perm_list ( id, code, description )
9 'Allow a user to perform fund propagation and rollover',
15 -- ensure that permission groups that are able to
16 -- rollover funds can continue to do so
20 WHERE code IN ('ADMIN_FUND_ROLLOVER'))
21 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
22 SELECT grp, perms_to_add.id as perm, depth, grantable
24 permission.grp_perm_map
26 --- Don't add the permissions if they have already been assigned
28 (SELECT DISTINCT grp FROM permission.grp_perm_map
29 INNER JOIN perms_to_add ON perm=perms_to_add.id)
31 --- Anybody who can view resources should also see reservations
35 FROM permission.perm_list
36 WHERE code = 'ADMIN_FUND'