Mercurial > gemma
diff schema/auth.sql @ 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 | 048580ec843d |
children | f9f1babe52ae |
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