1 -- Evergreen DB patch 0659.add_create_report_perms.sql
3 -- Add a permission to control the ability to create report templates
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('0659', :eg_version);
10 -- FIXME: add/check SQL statements to perform the upgrade
11 INSERT INTO permission.perm_list ( id, code, description ) VALUES
12 ( 516, 'CREATE_REPORT_TEMPLATE', oils_i18n_gettext( 516,
13 'Allows a user to create report templates', 'ppl', 'description' ));
15 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
16 SELECT grp, 516, depth, grantable
17 FROM permission.grp_perm_map
20 FROM permission.perm_list
21 WHERE code = 'RUN_REPORTS'