# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1547225006 -3600
# Node ID 30c76168e6d0297d178b4b1ad788ed0abeb78547
# Parent  0a53c33bc7b2097de7fffea75fce3ff5af0968d7
RLS gauge_measurements: Another attempt.

diff -r 0a53c33bc7b2 -r 30c76168e6d0 schema/auth.sql
--- 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