eole-risotto/posttemplate/10-fix-postgresql-permissions

#!/bin/bash

set -e

systemctl start postgresql.service

psql -Upostgres -c "grant all on all tables in schema public to risotto" risotto
psql -Upostgres -c "grant all on all sequences in schema public to risotto" risotto
psql -Upostgres -c "grant all on all functions in schema public to risotto" risotto
psql -Upostgres -c "grant all on all tables in schema public to tiramisu" tiramisu
psql -Upostgres -c "grant all on all sequences in schema public to tiramisu" tiramisu
psql -Upostgres -c "grant all on all functions in schema public to tiramisu" tiramisu

systemctl stop postgresql.service

exit 0