Mercurial > gemma
changeset 1782:30c76168e6d0
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