[taler-deployment] branch master updated: fix GRANT

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository deployment.

The following commit(s) were added to refs/heads/master by this push:
     new 3b08cc0  fix GRANT
3b08cc0 is described below

commit 3b08cc0b12a8a662ff10fdfbf579d6b86a19559e
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Sat Mar 4 20:51:37 2023 +0100

    fix GRANT
---
 netzbon/setup-exchange.sh | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

diff --git a/netzbon/setup-exchange.sh b/netzbon/setup-exchange.sh
index e6fc0cd..e496f71 100755
--- a/netzbon/setup-exchange.sh
+++ b/netzbon/setup-exchange.sh
@@ -66,9 +66,12 @@ sudo -i -u postgres createuser -d taler-exchange-closer || 
true
 sudo -i -u postgres createuser -d taler-exchange-aggregator || true
 sudo -i -u postgres createdb -O taler-exchange-httpd $EXCHANGE_DB || true
 
-echo "GRANT SELECT,INSERT,UPDATE,DELETE ON DATABASE \"${EXCHANGE_DB}\" TO 
\"taler-exchange-wire\";" | sudo -i -u postgres psql -f -
-echo "GRANT SELECT,INSERT,UPDATE,DELETE ON DATABASE \"${EXCHANGE_DB}\" TO 
\"taler-exchange-closer\";" | sudo -i -u postgres psql -f -
-echo "GRANT SELECT,INSERT,UPDATE,DELETE ON DATABASE \"${EXCHANGE_DB}\" TO 
\"taler-exchange-aggregator\";" | sudo -i -u postgres psql -f -
+echo "GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA exchange TO 
\"taler-exchange-wire\";" | sudo -i -u postgres psql -f - ${EXCHANGE_DB}
+echo "GRANT SELECT ON ALL TABLES IN SCHEMA _v TO \"taler-exchange-wire\";" | 
sudo -i -u postgres psql -f - ${EXCHANGE_DB}
+echo "GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA exchange TO 
\"taler-exchange-closer\";" | sudo -i -u postgres psql -f - ${EXCHANGE_DB}
+echo "GRANT SELECT ON ALL TABLES IN SCHEMA _v TO \"taler-exchange-closer\";" | 
sudo -i -u postgres psql -f - ${EXCHANGE_DB}
+echo "GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA exchange TO 
\"taler-exchange-aggregator\";" | sudo -i -u postgres psql -f - ${EXCHANGE_DB}
+echo "GRANT SELECT ON ALL TABLES IN SCHEMA _v TO 
\"taler-exchange-aggregator\";" | sudo -i -u postgres psql -f - ${EXCHANGE_DB}
 
 say "Configuring exchange"
 

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.