Mercurial > gemma
diff schema/gemma.sql @ 180:0423eab4ad45
Improve RLS policies for template data
The removed POLICY manage_templates missed a WITH CHECK (true),
because the USING clause is applied to new rows, too, if no
WITH CHECK is provided, thus implying a dead-lock
situation with the FK constraint on user_templates
(the POLICY requiring a row in user_templates while
INSERTing such row requires a row in templates).
New POLICY on user_templates prevents waterway_admin from
relating templates to users from other countries and
allows to write other policies more compact.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 17 Jul 2018 19:08:18 +0200 |
parents | 4e2451d561b1 |
children | 4df4e4bf480e |