commit 68dfd6de643d2dc9e762fcc6e10b752a800ea129
parent a2543eace6d2fb30ee523a6ad8305320ce1f0a2c
Author: MS <ms@taler.net>
Date: Wed, 6 Dec 2023 15:31:30 +0100
GRANTing on schema 'exchange'
Diffstat:
1 file changed, 2 insertions(+), 0 deletions(-)
diff --git a/contrib/taler-exchange-dbconfig b/contrib/taler-exchange-dbconfig
@@ -168,6 +168,8 @@ 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"
+ echo -e 'GRANT USAGE ON SCHEMA exchange TO "'"$GROUPIE"'"' \
+ | 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"