Mercurial > gemma

changeset 1842:56357561938f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added RLS for responsibility area on fairway dimensions.
author Raimund Renkert <raimund.renkert@intevation.de>
date Thu, 17 Jan 2019 09:27:28 +0100
parents 491f5b68da9e
children 1583cbca8ec5
files schema/auth.sql
diffstat 1 files changed, 4 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/auth.sql	Thu Jan 17 09:22:17 2019 +0100
+++ b/schema/auth.sql	Thu Jan 17 09:27:28 2019 +0100
@@ -121,6 +121,10 @@
     FOR ALL TO waterway_admin
     USING (utm_covers(area));
 
+CREATE POLICY responsibility_area ON waterway.fairway_dimensions
+    FOR ALL TO waterway_admin
+    USING (utm_covers(area));
+
 
 --
 -- RLS policies for imports and import config