Mercurial > gemma

changeset 179:382f631d8dd8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add missing privilege for waterway_admin
author Tom Gottfried <tom@intevation.de>
date Tue, 17 Jul 2018 18:21:56 +0200
parents 2111ad473961
children 0423eab4ad45
files schema/auth.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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;
 
 --