Mercurial > gemma

changeset 1913:2e0e7c1589c2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed RLS policy for waterway.stretches.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Jan 2019 18:15:41 +0100
parents a24d3b4b7ccd
children 89844ae6323a
files schema/auth.sql
diffstat 1 files changed, 3 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/auth.sql	Fri Jan 18 17:54:18 2019 +0100
+++ b/schema/auth.sql	Fri Jan 18 18:15:41 2019 +0100
@@ -125,6 +125,9 @@
     FOR ALL TO waterway_admin
     USING (utm_covers(area));
 
+CREATE POLICY responsibility_area ON waterway.stretches
+    FOR ALL TO sys_admin
+    USING (utm_covers(geom));
 
 --
 -- RLS policies for imports and import config