From cafd563f60a79b0dde5bade89779a2ba3ea75424 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 3 Jul 2017 10:13:12 -0400 Subject: [PATCH] JBAS-1786 Protect Stripe org settings Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.9-to-2.10-upgrade.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/KCLS/sql/schema/deploy/2.9-to-2.10-upgrade.sql b/KCLS/sql/schema/deploy/2.9-to-2.10-upgrade.sql index 4268506851..911f8eea02 100644 --- a/KCLS/sql/schema/deploy/2.9-to-2.10-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.9-to-2.10-upgrade.sql @@ -3317,6 +3317,17 @@ INSERT INTO config.record_attr_index_norm_map (attr,norm,pos) END IF; END $INSERT$; +-- protect stripe org settings +UPDATE config.org_unit_setting_type SET view_perm = ( + SELECT id FROM permission.perm_list + WHERE code = 'VIEW_CREDIT_CARD_PROCESSING' LIMIT 1 +) WHERE name LIKE 'credit.processor.stripe%' AND view_perm IS NULL; + +UPDATE config.org_unit_setting_type SET update_perm = ( + SELECT id FROM permission.perm_list + WHERE code = 'ADMIN_CREDIT_CARD_PROCESSING' LIMIT 1 +) WHERE name LIKE 'credit.processor.stripe%' AND update_perm IS NULL; + COMMIT; -- ROLLBACK; -- TESTING ONLY -- 2.11.0