postgres-migrations/008-create-dovecot-user.sql

CREATE ROLE dovecot_aliases WITH LOGIN PASSWORD '{{ dovecot.database_password }}';
GRANT CONNECT ON DATABASE mail_aliases TO dovecot_aliases;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO dovecot_aliases;