Mercurial > gemma

changeset 1782:30c76168e6d0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
RLS gauge_measurements: Another attempt.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 11 Jan 2019 17:43:26 +0100
parents 0a53c33bc7b2
children 8fd132b9cdbd
files schema/auth.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/auth.sql	Fri Jan 11 16:49:55 2019 +0100
+++ b/schema/auth.sql	Fri Jan 11 17:43:26 2019 +0100
@@ -144,7 +144,7 @@
 
 CREATE POLICY same_country ON waterway.gauge_measurements
     FOR ALL TO waterway_admin
-    USING (country_code = users.current_user_country());
+    USING ((fk_gauge_id).country_code = users.current_user_country());
 
 CREATE POLICY responsibility_area ON waterway.bottlenecks
     FOR ALL TO waterway_admin