From 5f8238c26c7dadf848c946103f80126f3edec49e Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sat, 20 Aug 2016 14:25:07 -0400 Subject: [PATCH] LP#1498155 - Also remove user-assigned SET_CIRC_MISSING perm. Signed-off-by: Chris Sharp Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql index a7f2911f12..faa2a6bbcd 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql @@ -4,6 +4,10 @@ BEGIN; DELETE FROM permission.grp_perm_map where perm in (select id from permission.perm_list where code='SET_CIRC_MISSING'); +--delete all instances from permission.usr_perm_map too +DELETE FROM permission.usr_perm_map where perm in +(select id from permission.perm_list where code='SET_CIRC_MISSING'); + --delete from permission.perm_list DELETE FROM permission.perm_list where code='SET_CIRC_MISSING'; -- 2.11.0