Mercurial > gemma
view schema/README.md @ 5025:4c658a8f34da
Fix row level security policies for waterway admin
Since 'staging_done OR' was added to the conditions to improve
performance for read access, it was also allowed to delete and partly
update entries with staging_done set to true but otherwise being
outside the country of the respective waterway admin. Using an extra
policy for each command and using the 'staging_done OR' tweak only
FOR SELECT should fix authorization while keeping performance.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 18 Mar 2020 12:16:42 +0100 |
parents | f2f0b776ba12 |
children |
line wrap: on
line source
The gemma database schema requires PostgreSQL >= 11. `dot.tmpl` is a template file for `postgresql_autodoc` to be more similiar to UML and leave out some less useful labels. See `../docker/README.md` Look at `updates/README.md` to how databases are updated.