From 649a59eadbca5a6b1ec7dcaa7cb85ac8126d9b8e Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 10 Jan 2014 11:29:37 -0500 Subject: [PATCH] Adding permissions to LocalAdmins and GlobalAdmins to administer staff client toolbars. --- .../sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql index c69e771aea..6c662009f3 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql @@ -14,5 +14,18 @@ INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('938', (SELECT INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('948', (SELECT id FROM vandelay.import_bib_trash_group WHERE label = 'PINES stripped tags')); INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('952', (SELECT id FROM vandelay.import_bib_trash_group WHERE label = 'PINES stripped tags')); +-- add permissions to administer the staff client toolbars +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR'), 0, TRUE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_ORG'), 0, TRUE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_USER'), 0, TRUE); +INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ((SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_TOOLBAR_FOR_WORKSTATION'), 0, TRUE); +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 = 'ADMIN_TOOLBAR'), 1, TR +UE); +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 = 'ADMIN_TOOLBAR_FOR_ORG'), 1, TR +UE); +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 = 'ADMIN_TOOLBAR_FOR_USER'), 1, TR +UE); +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 = 'ADMIN_TOOLBAR_FOR_WORKSTATION'), 1, TR +UE); COMMIT; -- 2.11.0