# HG changeset patch
# User Pascal Volk <user@localhost.localdomain.org>
# Date 1339706712 0
# Node ID 2fcf12fdecc25cdc9bed68544faa50ba2d83190d
# Parent  1498abbb6c91b1204a073ef32829ebdd4508064d
pgsql/set-permissions.py: Extended permissions.
Postfix needs read access on the postfix_gid view. Dovecot needs read
permissions on both mailboxformat columns.

diff -r 1498abbb6c91 -r 2fcf12fdecc2 pgsql/set-permissions.py
--- a/pgsql/set-permissions.py	Thu Jun 14 16:06:09 2012 +0000
+++ b/pgsql/set-permissions.py	Thu Jun 14 20:45:12 2012 +0000
@@ -93,19 +93,19 @@
     dbc.execute('GRANT SELECT, INSERT, UPDATE, DELETE ON %s TO %s' %
                 (dc_rw, dovecot))
     dbc.execute('GRANT SELECT ON alias, catchall, domain_data, domain_name, '
-                'maillocation, relocated, transport, users TO %s' % postfix)
+                'maillocation, postfix_gid, relocated, transport, users TO %s'
+                % postfix)
     dbc.close()
 
 
 def set_permissions84(dbh, dc_vers, dovecot, postfix):
     dc_rw_tbls = ('userquota_11', 'userquota')[dc_vers == 12]
-    dc_ro_tbls = 'maillocation, service_set, quotalimit'
-    pf_ro_tbls = 'alias, catchall, relocated, transport'
+    dc_ro_tbls = 'mailboxformat, maillocation, service_set, quotalimit'
+    pf_ro_tbls = 'alias, catchall, postfix_gid, relocated, transport'
     db = dict(dovecot=dovecot, postfix=postfix)
     db['dovecot_tbls'] = {
         'domain_data': 'domaindir, gid, qid, ssid',
         'domain_name': 'domainname, gid',
-        'mailboxformat': 'format',
         'users': 'gid, local_part, mid, passwd, qid, ssid, uid',
     }
     db['postfix_tbls'] = {