Azure Flexible Server for Postgres 소스 설정 가이드

CREATE USER clickpipes_user PASSWORD 'some-password';

GRANT USAGE ON SCHEMA "public" TO clickpipes_user;
GRANT SELECT ON ALL TABLES IN SCHEMA "public" TO clickpipes_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA "public" GRANT SELECT ON TABLES TO clickpipes_user;

ALTER USER clickpipes_user WITH REPLICATION;