Mercurial > gemma
changeset 1913:2e0e7c1589c2
Fixed RLS policy for waterway.stretches.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 18 Jan 2019 18:15:41 +0100 |
parents | a24d3b4b7ccd |
children | 89844ae6323a |
files | schema/auth.sql |
diffstat | 1 files changed, 3 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/auth.sql Fri Jan 18 17:54:18 2019 +0100 +++ b/schema/auth.sql Fri Jan 18 18:15:41 2019 +0100 @@ -125,6 +125,9 @@ FOR ALL TO waterway_admin USING (utm_covers(area)); +CREATE POLICY responsibility_area ON waterway.stretches + FOR ALL TO sys_admin + USING (utm_covers(geom)); -- -- RLS policies for imports and import config