Mercurial > gemma
diff schema/auth.sql @ 179:382f631d8dd8
Add missing privilege for waterway_admin
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 17 Jul 2018 18:21:56 +0200 |
parents | 4e2451d561b1 |
children | 0423eab4ad45 |
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; --