Files

26 lines
860 B
SQL

REVOKE ALL ON ALL TABLES IN SCHEMA public FROM PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON
users,
chats,
chat_members,
messages,
message_idempotency,
attachments,
message_attachments,
attachment_jobs,
outbox_events
TO messenger_api;
GRANT SELECT ON attachment_variants TO messenger_api;
GRANT SELECT, UPDATE, DELETE ON outbox_events TO messenger_dispatcher;
GRANT SELECT, UPDATE ON attachments, attachment_jobs TO messenger_worker;
GRANT SELECT, INSERT, UPDATE, DELETE ON attachment_variants TO messenger_worker;
GRANT INSERT ON attachment_replay_audit TO messenger_worker;
GRANT INSERT ON outbox_events TO messenger_worker;
GRANT SELECT, UPDATE, DELETE ON attachments TO messenger_reconciler;
GRANT SELECT ON attachment_variants, message_attachments TO messenger_reconciler;
GRANT pg_monitor TO messenger_exporter;