Mercurial > gemma

comparison schema/auth.sql @ 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 48791416bea5
children 40cbfd268aa9
comparison
equal deleted inserted replaced
1781:0a53c33bc7b2 1782:30c76168e6d0
142 -- Staging area 142 -- Staging area
143 -- TODO: add all relevant tables here 143 -- TODO: add all relevant tables here
144 144
145 CREATE POLICY same_country ON waterway.gauge_measurements 145 CREATE POLICY same_country ON waterway.gauge_measurements
146 FOR ALL TO waterway_admin 146 FOR ALL TO waterway_admin
147 USING (country_code = users.current_user_country()); 147 USING ((fk_gauge_id).country_code = users.current_user_country());
148 148
149 CREATE POLICY responsibility_area ON waterway.bottlenecks 149 CREATE POLICY responsibility_area ON waterway.bottlenecks
150 FOR ALL TO waterway_admin 150 FOR ALL TO waterway_admin
151 USING (utm_covers(area)); 151 USING (utm_covers(area));
152 152