commit 0aa2c218d8ba9c894235fd84c2d0a87f3154855d parent f9a43b8213173d618de84397b236e1e5a9f1368d Author: MS <ms@taler.net> Date: Sun, 3 Dec 2023 20:36:49 +0100 USAGE right to the bank on _v Diffstat:
| M | contrib/libeufin-bank-dbconfig | | | 5 | +++++ |
1 file changed, 5 insertions(+), 0 deletions(-)
diff --git a/contrib/libeufin-bank-dbconfig b/contrib/libeufin-bank-dbconfig @@ -105,6 +105,11 @@ then echo "Failed to grant access to database '$DBNAME' to '$DBUSER'." 1>&2 exit 1 fi + if ! echo "GRANT USAGE ON SCHEMA _v TO \"$DBUSER\"" \ + | sudo -i -u postgres psql "$DBNAME" + then + echo "Failed to grant usage privilege on schema '_v' to '$DBUSER'. Maybe OK if it does not exist. Will continue." 1>&2 + if ! echo "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA _v TO \"$DBUSER\"" \ | sudo -i -u postgres psql "$DBNAME" then