diff options
author | MS <ms@taler.net> | 2023-12-06 13:47:31 +0100 |
---|---|---|
committer | MS <ms@taler.net> | 2023-12-06 13:47:31 +0100 |
commit | c12426e1e485038637fa46163f0dacf97c3b59a1 (patch) | |
tree | 475c93601f3b7a20fa50961a16e7d550d62b1c92 | |
parent | eab51cdda48669bce88c2d34c3015ad5c87340de (diff) | |
download | libeufin-c12426e1e485038637fa46163f0dacf97c3b59a1.tar.gz libeufin-c12426e1e485038637fa46163f0dacf97c3b59a1.tar.bz2 libeufin-c12426e1e485038637fa46163f0dacf97c3b59a1.zip |
GRANTing for conversion
-rwxr-xr-x | contrib/libeufin-dbconfig | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/contrib/libeufin-dbconfig b/contrib/libeufin-dbconfig index 15d0affe..1e9ba109 100755 --- a/contrib/libeufin-dbconfig +++ b/contrib/libeufin-dbconfig @@ -197,10 +197,10 @@ if ! echo "GRANT USAGE ON SCHEMA libeufin_nexus TO \"$BANK_DBUSER\"" \ then exit_fail "Failed to grant usage privilege on schema 'libeufin_nexus' to '$BANK_DBUSER'." 1>&2 fi -if ! echo "GRANT SELECT, INSERT, TRIGGER ON ALL TABLES IN SCHEMA libeufin_nexus TO \"$BANK_DBUSER\"" \ +if ! echo "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA libeufin_nexus TO \"$BANK_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 + exit_fail "Failed to grant all privileges on schema 'libeufin_nexus' to '$BANK_DBUSER'." 1>&2 fi sudo -u "$BANK_DBUSER" "$BANK_DBINIT" -c "$BANK_CFGFILE" @@ -209,10 +209,10 @@ if ! echo "GRANT USAGE ON SCHEMA libeufin_bank TO \"$NEXUS_DBUSER\"" \ 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\"" \ +if ! echo "GRANT ALL PRIVILEGES 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 + exit_fail "Failed to grant all privileges on schema 'libeufin_bank' to '$NEXUS_DBUSER'." 1>&2 fi echo "Database configuration finished." 1>&2 |