summaryrefslogtreecommitdiff
path: root/debian/db/install/pgsql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2021-01-02 21:21:34 +0100
committerChristian Grothoff <christian@grothoff.org>2021-01-02 21:21:34 +0100
commit0ccc6504209c155ee036893288ac0bc7e988d43a (patch)
tree5c385e80147f49271536afd626fe04b4ce27a14f /debian/db/install/pgsql
parent7334cfc40995c98aa550fedc7b249d9c08100028 (diff)
downloadmerchant-0ccc6504209c155ee036893288ac0bc7e988d43a.tar.gz
merchant-0ccc6504209c155ee036893288ac0bc7e988d43a.tar.bz2
merchant-0ccc6504209c155ee036893288ac0bc7e988d43a.zip
fix #6673: fix access rights on package install
Diffstat (limited to 'debian/db/install/pgsql')
-rwxr-xr-xdebian/db/install/pgsql5
1 files changed, 5 insertions, 0 deletions
diff --git a/debian/db/install/pgsql b/debian/db/install/pgsql
index 8173aeff..a69ac671 100755
--- a/debian/db/install/pgsql
+++ b/debian/db/install/pgsql
@@ -45,6 +45,11 @@ if [ -f /etc/dbconfig-common/taler-merchant.conf ]; then
. /etc/dbconfig-common/taler-merchant.conf
case "$dbc_dbtype" in
pgsql)
+ echo "GRANT INSERT, SELECT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO \"$dbc_dbuser\";" \
+ | sudo -u postgres psql "postgres:///$dbc_dbname"
+ echo "GRANT SELECT, UPDATE ON ALL SEQUENCES IN SCHEMA public TO \"$dbc_dbuser\";" \
+ | sudo -u postgres psql "postgres:///$dbc_dbname"
+
taler-config -w \
-c /etc/taler-merchant.conf \
-s "merchantdb-postgres" \