Mercurial > gemma

diff schema/auth.sql @ 5016:cf25b23e3eec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Keep historic data of waterway axis ... and accordingly configure the respective layer as WMS-T.
author Tom Gottfried <tom@intevation.de>
date Fri, 13 Mar 2020 17:34:59 +0100
parents 388947a3050d
children 4c658a8f34da
line wrap: on
line diff
--- a/schema/auth.sql	Fri Mar 13 14:13:32 2020 +0100
+++ b/schema/auth.sql	Fri Mar 13 17:34:59 2020 +0100
@@ -215,11 +215,6 @@
     USING ((SELECT ST_Covers(a,
             ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
         FROM users.current_user_area_utm() AS a (a)));
-CREATE POLICY responsibility_area_delete ON waterway.waterway_axis
-    FOR DELETE TO waterway_admin
-    USING ((SELECT ST_Covers(a,
-            ST_Transform(CAST(wtwaxs AS geometry), ST_SRID(a)))
-        FROM users.current_user_area_utm() AS a (a)));
 
 --
 -- RLS policies for imports and import config