exchange

commit a2543eace6d2fb30ee523a6ad8305320ce1f0a2c
parent 381c5efb612e5393bb5a4e85420de8096b95a6e5
Author: MS <ms@taler.net>
Date:   Wed,  6 Dec 2023 15:21:48 +0100

GRANTing on _v for other exchange services

Diffstat:
M
contrib/taler-exchange-dbconfig
 | 
7
+++++++

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