Files
mtusi2026lab7/postgres/init-roles.sh

27 lines
1.5 KiB
Bash

#!/bin/sh
set -eu
: "${API_DB_USER:?API_DB_USER is required}"
: "${API_DB_PASSWORD:?API_DB_PASSWORD is required}"
: "${WORKER_DB_USER:?WORKER_DB_USER is required}"
: "${WORKER_DB_PASSWORD:?WORKER_DB_PASSWORD is required}"
: "${OUTBOX_DB_USER:?OUTBOX_DB_USER is required}"
: "${OUTBOX_DB_PASSWORD:?OUTBOX_DB_PASSWORD is required}"
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" --set ON_ERROR_STOP=1 \
--set api_user="$API_DB_USER" --set api_password="$API_DB_PASSWORD" \
--set worker_user="$WORKER_DB_USER" --set worker_password="$WORKER_DB_PASSWORD" \
--set outbox_user="$OUTBOX_DB_USER" --set outbox_password="$OUTBOX_DB_PASSWORD" <<'SQL'
SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'api_user', :'api_password') \gexec
SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'worker_user', :'worker_password') \gexec
SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'outbox_user', :'outbox_password') \gexec
SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'api_user') \gexec
SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'worker_user') \gexec
SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'outbox_user') \gexec
GRANT USAGE ON SCHEMA public TO :"api_user", :"worker_user", :"outbox_user";
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO :"api_user", :"worker_user";
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT USAGE, SELECT ON SEQUENCES TO :"api_user", :"worker_user";
SQL