libeufin

commit eab51cdda48669bce88c2d34c3015ad5c87340de
parent aabfb5224e1d1298281241296121a27700a1acf0
Author: MS <ms@taler.net>
Date:   Wed,  6 Dec 2023 00:14:54 +0100

schema allowance must be mutual

Diffstat:
M
contrib/libeufin-dbconfig
 | 
11
+++++++++++

1 file changed, 11 insertions(+), 0 deletions(-)
diff --git a/contrib/libeufin-dbconfig b/contrib/libeufin-dbconfig
@@ -204,4 +204,15 @@ then
 fi
 
 sudo -u "$BANK_DBUSER" "$BANK_DBINIT" -c "$BANK_CFGFILE"
+if ! echo "GRANT USAGE ON SCHEMA libeufin_bank TO \"$NEXUS_DBUSER\"" \
+        | sudo -i -u postgres psql "$DBNAME"
+then
+        exit_fail "Failed to grant usage privilege on schema 'libeufin_bank' to '$NEXUS_DBUSER'." 1>&2
+fi
+if ! echo "GRANT SELECT, INSERT, TRIGGER ON ALL TABLES IN SCHEMA libeufin_bank TO \"$NEXUS_DBUSER\"" \
+        | sudo -i -u postgres psql "$DBNAME"
+then
+        exit_fail "Failed to grant SELECT, INSERT, TRIGGER privileges on schema 'libeufin_nexus' to '$BANK_DBUSER'." 1>&2
+fi
+
 echo "Database configuration finished." 1>&2