Mercurial > gemma

comparison schema/auth.sql @ 1842:56357561938f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added RLS for responsibility area on fairway dimensions.
author Raimund Renkert <raimund.renkert@intevation.de>
date Thu, 17 Jan 2019 09:27:28 +0100
parents 06d162ac0b9f
children f63712670c25
comparison
equal deleted inserted replaced
1841:491f5b68da9e 1842:56357561938f
119 119
120 CREATE POLICY responsibility_area ON waterway.sounding_results 120 CREATE POLICY responsibility_area ON waterway.sounding_results
121 FOR ALL TO waterway_admin 121 FOR ALL TO waterway_admin
122 USING (utm_covers(area)); 122 USING (utm_covers(area));
123 123
124 CREATE POLICY responsibility_area ON waterway.fairway_dimensions
125 FOR ALL TO waterway_admin
126 USING (utm_covers(area));
127
124 128
125 -- 129 --
126 -- RLS policies for imports and import config 130 -- RLS policies for imports and import config
127 -- 131 --
128 132