surtr: ...

1 files changed, 2 insertions, 2 deletions

diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix
index 71fd6463..c1993431 100644
--- a/hosts/surtr/postgresql.nix
+++ b/hosts/surtr/postgresql.nix
@@ -15,10 +15,10 @@ in {
         CREATE DATABASE "email" WITH TEMPLATE "template0" ENCODING "UTF8" LOCALE "C";
         CREATE USER "postfix";
         GRANT CONNECT ON DATABASE "email" TO "postfix";
-        GRANT SELECT ON ALL TABLES IN SCHEMA public TO "postfix";
+        ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO "postfix";
         CREATE USER "dovecot2";
         GRANT CONNECT ON DATABASE "email" TO "dovecot2";
-        GRANT SELECT ON ALL TABLES IN SCHEMA public TO "dovecot2";
+        ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO "dovecot2";
       '';
     };