view misc/gemma.service @ 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 42e7088824be
children
line wrap: on
line source

[Unit]
Description=Gemma Server
After=network.target

[Service]
Type=simple
ExecStart=/home/gemma/gemma/cmd/gemma/gemma -c /home/gemma/gemma.toml
User=gemma
Group=gemma
Restart=on-failure

[Install]
WantedBy=multi-user.target