diff options
author | MS <ms@taler.net> | 2023-12-06 00:14:54 +0100 |
---|---|---|
committer | MS <ms@taler.net> | 2023-12-06 00:15:21 +0100 |
commit | eab51cdda48669bce88c2d34c3015ad5c87340de (patch) | |
tree | 49ba127d60367a5fa4b191a6422b4d3022a7383f | |
parent | aabfb5224e1d1298281241296121a27700a1acf0 (diff) | |
download | libeufin-eab51cdda48669bce88c2d34c3015ad5c87340de.tar.gz libeufin-eab51cdda48669bce88c2d34c3015ad5c87340de.tar.bz2 libeufin-eab51cdda48669bce88c2d34c3015ad5c87340de.zip |
schema allowance must be mutual
-rwxr-xr-x | contrib/libeufin-dbconfig | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/contrib/libeufin-dbconfig b/contrib/libeufin-dbconfig index ae35f9fb..15d0affe 100755 --- 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 |