5 lines
313 B
SQL
5 lines
313 B
SQL
CREATE ROLE postfix_aliases WITH LOGIN PASSWORD '{{ postfix.database_password }}';
|
|
CREATE DATABASE mail_aliases;
|
|
GRANT CONNECT ON DATABASE mail_aliases TO postfix_aliases;
|
|
CREATE TABLE aliases(alias VARCHAR(255) PRIMARY KEY, username VARCHAR(255));
|
|
GRANT SELECT ON ALL TABLES IN SCHEMA public TO postfix_aliases;
|