pgsql/set-permissions.py: Extended permissions. v0.6.x
authorPascal Volk <user@localhost.localdomain.org>
Thu, 14 Jun 2012 20:45:12 +0000
branchv0.6.x
changeset 558 2fcf12fdecc2
parent 557 1498abbb6c91
child 559 cc0f67f99780
pgsql/set-permissions.py: Extended permissions. Postfix needs read access on the postfix_gid view. Dovecot needs read permissions on both mailboxformat columns.
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'] = {