diff options
| author | MS <ms@taler.net> | 2023-12-06 15:21:48 +0100 |
|---|---|---|
| committer | MS <ms@taler.net> | 2023-12-06 15:21:48 +0100 |
| commit | a2543eace6d2fb30ee523a6ad8305320ce1f0a2c (patch) | |
| tree | 52341e8d7a53a381f182fceed5bbe4076159a5f4 /contrib/taler-exchange-dbconfig | |
| parent | 381c5efb612e5393bb5a4e85420de8096b95a6e5 (diff) | |
GRANTing on _v for other exchange services
Diffstat (limited to 'contrib/taler-exchange-dbconfig')
| -rwxr-xr-x | contrib/taler-exchange-dbconfig | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/contrib/taler-exchange-dbconfig b/contrib/taler-exchange-dbconfig index a2187af81..ec3584656 100755 --- a/contrib/taler-exchange-dbconfig +++ b/contrib/taler-exchange-dbconfig @@ -168,6 +168,13 @@ then echo -e 'GRANT SELECT,INSERT,UPDATE ON ALL TABLES IN SCHEMA exchange TO "'"$GROUPIE"'";\n' \ 'GRANT USAGE ON ALL SEQUENCES IN SCHEMA exchange TO "'"$GROUPIE"'";\n' \ | sudo -u "$DBUSER" psql "$DBNAME" + # FIXME: double-check the following GRANTs + echo -e 'GRANT USAGE ON SCHEMA _v TO "'"$GROUPIE"'"' \ + | sudo -u "$DBUSER" psql "$DBNAME" + echo -e 'GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA _v TO "'"$GROUPIE"'"' \ + | sudo -u "$DBUSER" psql "$DBNAME" + + fi done fi |