3 SELECT evergreen.upgrade_deps_block_check('0547', :eg_version); -- dbwells
5 -- account for spelling errors (Admin != Administrator)
6 \qecho This might not insert much if you passed through 0542 on your way here,
7 \qecho but one group was missed there as well
9 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
11 pgt.id, perm.id, aout.depth, TRUE
13 permission.grp_tree pgt,
14 permission.perm_list perm,
15 actor.org_unit_type aout
17 pgt.name = 'Cataloging Administrator' AND
18 aout.name = 'Consortium' AND
20 'ADMIN_IMPORT_ITEM_ATTR_DEF',
21 'ADMIN_MERGE_PROFILE',
22 'CREATE_AUTHORITY_IMPORT_IMPORT_DEF',
23 'CREATE_BIB_IMPORT_FIELD_DEF',
26 'CREATE_IMPORT_ITEM_ATTR_DEF',
27 'CREATE_IMPORT_TRASH_FIELD',
28 'CREATE_MERGE_PROFILE',
29 'CREATE_MONOGRAPH_PART',
30 'CREATE_VOLUME_PREFIX',
31 'CREATE_VOLUME_SUFFIX',
32 'DELETE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
35 'DELETE_IMPORT_ITEM_ATTR_DEF',
36 'DELETE_IMPORT_TRASH_FIELD',
37 'DELETE_MERGE_PROFILE',
38 'DELETE_MONOGRAPH_PART',
39 'DELETE_VOLUME_PREFIX',
40 'DELETE_VOLUME_SUFFIX',
42 'UPDATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
43 'UPDATE_BIB_IMPORT_IMPORT_FIELD_DEF',
45 'UPDATE_IMPORT_ITEM_ATTR_DEF',
46 'UPDATE_IMPORT_TRASH_FIELD',
47 'UPDATE_MERGE_PROFILE',
48 'UPDATE_MONOGRAPH_PART',
49 'UPDATE_VOLUME_PREFIX',
50 'UPDATE_VOLUME_SUFFIX'
53 FROM permission.grp_perm_map AS map
56 AND map.perm = perm.id
59 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
61 pgt.id, perm.id, aout.depth, TRUE
63 permission.grp_tree pgt,
64 permission.perm_list perm,
65 actor.org_unit_type aout
67 pgt.name = 'Cataloging Administrator' AND
68 aout.name = 'System' AND
70 'CREATE_COPY_STAT_CAT',
71 'CREATE_COPY_STAT_CAT_ENTRY',
72 'CREATE_COPY_STAT_CAT_ENTRY_MAP',
74 'SHARE_REPORT_FOLDER',
75 'UPDATE_COPY_LOCATION',
76 'UPDATE_COPY_STAT_CAT',
77 'UPDATE_COPY_STAT_CAT_ENTRY',
81 FROM permission.grp_perm_map AS map
84 AND map.perm = perm.id
87 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
89 pgt.id, perm.id, aout.depth, TRUE
91 permission.grp_tree pgt,
92 permission.perm_list perm,
93 actor.org_unit_type aout
95 pgt.name = 'Circulation Administrator' AND
96 aout.name = 'Branch' AND
101 FROM permission.grp_perm_map AS map
104 AND map.perm = perm.id
107 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
109 pgt.id, perm.id, aout.depth, TRUE
111 permission.grp_tree pgt,
112 permission.perm_list perm,
113 actor.org_unit_type aout
115 pgt.name = 'Circulation Administrator' AND
116 aout.name = 'Consortium' AND
118 'ADMIN_MAX_FINE_RULE',
119 'CREATE_CIRC_DURATION',
120 'DELETE_CIRC_DURATION',
121 'MARK_ITEM_MISSING_PIECES',
122 'UPDATE_CIRC_DURATION',
123 'UPDATE_HOLD_REQUEST_TIME',
124 'UPDATE_NET_ACCESS_LEVEL',
125 'VIEW_CIRC_MATRIX_MATCHPOINT',
126 'VIEW_HOLD_MATRIX_MATCHPOINT'
129 FROM permission.grp_perm_map AS map
132 AND map.perm = perm.id
135 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
137 pgt.id, perm.id, aout.depth, TRUE
139 permission.grp_tree pgt,
140 permission.perm_list perm,
141 actor.org_unit_type aout
143 pgt.name = 'Circulation Administrator' AND
144 aout.name = 'System' AND
146 'ADMIN_BOOKING_RESERVATION',
147 'ADMIN_BOOKING_RESERVATION_ATTR_MAP',
148 'ADMIN_BOOKING_RESERVATION_ATTR_VALUE_MAP',
149 'ADMIN_BOOKING_RESOURCE',
150 'ADMIN_BOOKING_RESOURCE_ATTR',
151 'ADMIN_BOOKING_RESOURCE_ATTR_MAP',
152 'ADMIN_BOOKING_RESOURCE_ATTR_VALUE',
153 'ADMIN_BOOKING_RESOURCE_TYPE',
154 'ADMIN_COPY_LOCATION_ORDER',
155 'ADMIN_HOLD_CANCEL_CAUSE',
159 'COPY_TRANSIT_RECEIVE',
161 'CREATE_BILLING_TYPE',
162 'CREATE_NON_CAT_TYPE',
163 'CREATE_PATRON_STAT_CAT',
164 'CREATE_PATRON_STAT_CAT_ENTRY',
165 'CREATE_PATRON_STAT_CAT_ENTRY_MAP',
166 'CREATE_USER_GROUP_LINK',
167 'DELETE_BILLING_TYPE',
168 'DELETE_NON_CAT_TYPE',
169 'DELETE_PATRON_STAT_CAT',
170 'DELETE_PATRON_STAT_CAT_ENTRY',
171 'DELETE_PATRON_STAT_CAT_ENTRY_MAP',
173 'group_application.user.staff',
175 'MARK_ITEM_AVAILABLE',
177 'MARK_ITEM_CHECKED_OUT',
179 'MARK_ITEM_IN_PROCESS',
180 'MARK_ITEM_IN_TRANSIT',
183 'MARK_ITEM_ON_HOLDS_SHELF',
184 'MARK_ITEM_ON_ORDER',
185 'MARK_ITEM_RESHELVING',
187 'money.collections_tracker.create',
188 'money.collections_tracker.delete',
192 'REMOVE_USER_GROUP_LINK',
193 'SET_CIRC_CLAIMS_RETURNED',
194 'SET_CIRC_CLAIMS_RETURNED.override',
199 'UPDATE_NON_CAT_TYPE',
200 'UPDATE_PATRON_CLAIM_NEVER_CHECKED_OUT_COUNT',
201 'UPDATE_PATRON_CLAIM_RETURN_COUNT',
202 'UPDATE_PICKUP_LIB_FROM_HOLDS_SHELF',
203 'UPDATE_PICKUP_LIB_FROM_TRANSIT',
205 'VIEW_REPORT_OUTPUT',
206 'VIEW_STANDING_PENALTY',
211 FROM permission.grp_perm_map AS map
214 AND map.perm = perm.id