From a2543eace6d2fb30ee523a6ad8305320ce1f0a2c Mon Sep 17 00:00:00 2001
From: MS <ms@taler.net>
Date: Wed, 6 Dec 2023 15:21:48 +0100
Subject: GRANTing on _v for other exchange services

---
 contrib/taler-exchange-dbconfig | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'contrib/taler-exchange-dbconfig')

diff --git a/contrib/taler-exchange-dbconfig b/contrib/taler-exchange-dbconfig
index a2187af81..ec3584656 100755
--- a/contrib/taler-exchange-dbconfig
+++ b/contrib/taler-exchange-dbconfig
@@ -168,6 +168,13 @@ then
             echo -e 'GRANT SELECT,INSERT,UPDATE ON ALL TABLES IN SCHEMA exchange TO "'"$GROUPIE"'";\n' \
                     'GRANT USAGE ON ALL SEQUENCES IN SCHEMA exchange TO "'"$GROUPIE"'";\n' \
                 | sudo -u "$DBUSER" psql "$DBNAME"
+	    # FIXME: double-check the following GRANTs
+            echo -e 'GRANT USAGE ON SCHEMA _v TO "'"$GROUPIE"'"' \
+                | sudo -u "$DBUSER" psql "$DBNAME"
+            echo -e 'GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA _v TO "'"$GROUPIE"'"' \
+                | sudo -u "$DBUSER" psql "$DBNAME"
+
+
         fi
     done
 fi
-- 
cgit v1.2.3