3 SELECT evergreen.upgrade_deps_block_check('0542', :eg_version); -- phasefx
5 INSERT INTO permission.perm_list VALUES
6 (485, 'CREATE_VOLUME_SUFFIX', oils_i18n_gettext(485, 'Create suffix label definition.', 'ppl', 'description'))
7 ,(486, 'UPDATE_VOLUME_SUFFIX', oils_i18n_gettext(486, 'Update suffix label definition.', 'ppl', 'description'))
8 ,(487, 'DELETE_VOLUME_SUFFIX', oils_i18n_gettext(487, 'Delete suffix label definition.', 'ppl', 'description'))
9 ,(488, 'CREATE_VOLUME_PREFIX', oils_i18n_gettext(488, 'Create prefix label definition.', 'ppl', 'description'))
10 ,(489, 'UPDATE_VOLUME_PREFIX', oils_i18n_gettext(489, 'Update prefix label definition.', 'ppl', 'description'))
11 ,(490, 'DELETE_VOLUME_PREFIX', oils_i18n_gettext(490, 'Delete prefix label definition.', 'ppl', 'description'))
12 ,(491, 'CREATE_MONOGRAPH_PART', oils_i18n_gettext(491, 'Create monograph part definition.', 'ppl', 'description'))
13 ,(492, 'UPDATE_MONOGRAPH_PART', oils_i18n_gettext(492, 'Update monograph part definition.', 'ppl', 'description'))
14 ,(493, 'DELETE_MONOGRAPH_PART', oils_i18n_gettext(493, 'Delete monograph part definition.', 'ppl', 'description'))
15 ,(494, 'ADMIN_CODED_VALUE', oils_i18n_gettext(494, 'Create/Update/Delete SVF Record Attribute Coded Value Map', 'ppl', 'description'))
16 ,(495, 'ADMIN_SERIAL_ITEM', oils_i18n_gettext(495, 'Create/Retrieve/Update/Delete Serial Item', 'ppl', 'description'))
17 ,(496, 'ADMIN_SVF', oils_i18n_gettext(496, 'Create/Update/Delete SVF Record Attribute Defintion', 'ppl', 'description'))
18 ,(497, 'CREATE_BIB_PTYPE', oils_i18n_gettext(497, 'Create Bibliographic Record Peer Type', 'ppl', 'description'))
19 ,(498, 'CREATE_PURCHASE_REQUEST', oils_i18n_gettext(498, 'Create User Purchase Request', 'ppl', 'description'))
20 ,(499, 'DELETE_BIB_PTYPE', oils_i18n_gettext(499, 'Delete Bibliographic Record Peer Type', 'ppl', 'description'))
21 ,(500, 'MAP_MONOGRAPH_PART', oils_i18n_gettext(500, 'Create/Update/Delete Copy Monograph Part Map', 'ppl', 'description'))
22 ,(501, 'MARK_ITEM_MISSING_PIECES', oils_i18n_gettext(501, 'Allows the Mark Item Missing Pieces action.', 'ppl', 'description'))
23 ,(502, 'UPDATE_BIB_PTYPE', oils_i18n_gettext(502, 'Update Bibliographic Record Peer Type', 'ppl', 'description'))
24 ,(503, 'UPDATE_HOLD_REQUEST_TIME', oils_i18n_gettext(503, 'Allows editing of a hold''s request time, and/or its Cut-in-line/Top-of-queue flag.', 'ppl', 'description'))
25 ,(504, 'UPDATE_PICKLIST', oils_i18n_gettext(504, 'Allows update/re-use of an acquisitions pick/selection list.', 'ppl', 'description'))
26 ,(505, 'UPDATE_WORKSTATION', oils_i18n_gettext(505, 'Allows update of a workstation during workstation registration override.', 'ppl', 'description'))
27 ,(506, 'VIEW_USER_SETTING_TYPE', oils_i18n_gettext(506, 'Allows viewing of configurable user setting types.', 'ppl', 'description'))
32 INSERT INTO permission.grp_perm_map ( grp, perm, depth )
37 FROM permission.perm_list
39 'CREATE_PURCHASE_REQUEST'
44 INSERT INTO permission.grp_perm_map ( grp, perm, depth )
49 FROM permission.perm_list
51 'VIEW_USER_SETTING_TYPE'
54 -- stock Circulators group
56 INSERT INTO permission.grp_perm_map ( grp, perm, depth )
61 FROM permission.perm_list
63 'MARK_ITEM_MISSING_PIECES'
66 --- stock Circulation Administrator group
68 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
74 FROM permission.perm_list
76 'MARK_ITEM_MISSING_PIECES'
77 ,'UPDATE_HOLD_REQUEST_TIME'
80 -- stock Catalogers group
82 INSERT INTO permission.grp_perm_map ( grp, perm, depth )
87 FROM permission.perm_list
93 -- stock Cataloging Administrator group
95 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
101 FROM permission.perm_list
105 ,'CREATE_VOLUME_SUFFIX'
106 ,'UPDATE_VOLUME_SUFFIX'
107 ,'DELETE_VOLUME_SUFFIX'
108 ,'CREATE_VOLUME_PREFIX'
109 ,'UPDATE_VOLUME_PREFIX'
110 ,'DELETE_VOLUME_PREFIX'
111 ,'CREATE_MONOGRAPH_PART'
112 ,'UPDATE_MONOGRAPH_PART'
113 ,'DELETE_MONOGRAPH_PART'
119 -- stock Serials group
121 INSERT INTO permission.grp_perm_map ( grp, perm, depth )
126 FROM permission.perm_list
132 -- stock Acquisitions group
134 INSERT INTO permission.grp_perm_map ( grp, perm, depth )
139 FROM permission.perm_list
144 --- stock Acquisitions Administrator group
146 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
152 FROM permission.perm_list
157 --- stock Local Administrator group
159 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
165 FROM permission.perm_list
170 --- stock System Administrator group
172 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
178 FROM permission.perm_list
183 --- stock Global Administrator group
185 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
191 FROM permission.perm_list