summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMS <ms@taler.net>2023-12-03 20:36:49 +0100
committerMS <ms@taler.net>2023-12-03 20:36:49 +0100
commit0aa2c218d8ba9c894235fd84c2d0a87f3154855d (patch)
tree877e110ceeef35d6d913a571444e3c0206ee0c0a
parentf9a43b8213173d618de84397b236e1e5a9f1368d (diff)
downloadlibeufin-0aa2c218d8ba9c894235fd84c2d0a87f3154855d.tar.gz
libeufin-0aa2c218d8ba9c894235fd84c2d0a87f3154855d.tar.bz2
libeufin-0aa2c218d8ba9c894235fd84c2d0a87f3154855d.zip
USAGE right to the bank on _v
-rwxr-xr-xcontrib/libeufin-bank-dbconfig5
1 files changed, 5 insertions, 0 deletions
diff --git a/contrib/libeufin-bank-dbconfig b/contrib/libeufin-bank-dbconfig
index b916b734..1fffc0ac 100755
--- 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