From 159cc0c0c2948174561ac864372bd5bcbd0a9f50 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 20 Dec 2017 12:38:23 -0500 Subject: [PATCH] adding new CONTAINER_BATCH_UPDATE perm to appropriate groups --- Open-ILS/src/sql/Pg/version-upgrade/post-3.0-upgrade.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/post-3.0-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/post-3.0-upgrade.sql index 6b14850e54..f37801ecaf 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/post-3.0-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/post-3.0-upgrade.sql @@ -1,3 +1,12 @@ +BEGIN; +-- Add the CONTAINER_BATCH_UPDATE perm to LocalAdmin, LibraryManager, and GlobalAdmin +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES +((SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'CONTAINER_BATCH_UPDATE'), 0, FALSE), +((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'CONTAINER_BATCH_UPDATE'), 0, FALSE), +((SELECT id FROM permission.grp_tree WHERE name = 'LibraryManager'), (SELECT id FROM permission.perm_list WHERE code = 'CONTAINER_BATCH_UPDATE'), 0, FALSE); + +COMMIT; + \echo --------------------------------------------------------------------- \echo Reingest authority records. This can be canceled via Ctrl-C and run \echo at a later time; see the upgrade script. Note that if you cancel now, -- 2.11.0