# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1531844516 -7200
# Node ID 382f631d8dd8de7685c7685a7f727deaca7b5777
# Parent  2111ad473961cf537c05b6d56b835f71f1e63cd9
Add missing privilege for waterway_admin

diff -r 2111ad473961 -r 382f631d8dd8 schema/auth.sql
--- a/schema/auth.sql	Tue Jul 17 17:07:55 2018 +0200
+++ b/schema/auth.sql	Tue Jul 17 18:21:56 2018 +0200
@@ -22,7 +22,7 @@
 GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA gemma_waterway, gemma_fairway
       TO waterway_admin;
 -- TODO: will there ever be UPDATEs or can we drop that due to historicisation?
-GRANT INSERT, UPDATE ON templates, user_templates TO waterway_admin;
+GRANT INSERT, UPDATE, DELETE ON templates, user_templates TO waterway_admin;
 GRANT SELECT ON responsibility_areas TO waterway_admin;
 
 --