taler-deployment

commit 3b08cc0b12a8a662ff10fdfbf579d6b86a19559e
parent 60a8cd26f307f232ef0a31771482ac6ed115cffd
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sat,  4 Mar 2023 20:51:37 +0100

fix GRANT

Diffstat:
M
netzbon/setup-exchange.sh
 | 
9
++++++---

1 file changed, 6 insertions(+), 3 deletions(-)
diff --git 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"