1 -- Evergreen DB patch XXXX.data.lp1068287_add_create_precat_perm.sql
3 -- Add a permission to prevent untrained/non-authorized staff from
4 -- adding pre-cat copies/items due to barcode misscans.
8 -- check whether patch can be applied
9 --SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
11 INSERT INTO permission.perm_list(id, code, description)
12 VALUES (618, 'CREATE_PRECAT', 'Allows user to create a pre-catalogued copy');
14 -- Add this new permission to any group with Staff login perm.
15 -- Manually remove if needed
16 insert into permission.grp_perm_map(perm, grp, depth) select 618, map.grp, 0 from permission.grp_perm_map as map where map.perm = 2;