diff --git a/pillar/dbserver/cluster-A.sls b/pillar/dbserver/cluster-A.sls --- a/pillar/dbserver/cluster-A.sls +++ b/pillar/dbserver/cluster-A.sls @@ -27,6 +27,14 @@ privileges: - ALL + mailManagement: + password: dbserver/cluster-A/users/mailManagement + privileges: + - database: mail + scope: schema + privileges: + - ALL + netbox: password: dbserver/cluster-A/users/netbox privileges: @@ -51,6 +59,17 @@ privileges: - ALL + postfix: + password: dbserver/cluster-A/users/postfix + privileges: + - database: mail + scope: table + schema: public + tables: + - ALL + privileges: + - SELECT + databases: airflow: encoding: UTF8 @@ -66,6 +85,10 @@ encoding: UTF8 owner: orbeon + mail: + encoding: UTF8 + owner: mailManagement + netbox: encoding: UTF8 owner: netbox @@ -97,3 +120,8 @@ user: openfire ips: &docker002 172.27.27.5/32 method: password + + - db: mail + user: postfix + ips: 172.27.27.3/32 + method: password