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;