doc/web/source/pgsql_set_permissionspermissions.rst
author martin f. krafft <madduck@debian.org>
Wed, 08 Aug 2012 14:37:29 +0000
changeset 586 cd1200d06700
parent 579 be0906181a10
child 626 f151defe7078
permissions -rw-r--r--
VMM/common: Improve search_address complexity Checking the dictionary (a hash) for existence of a key is likely to be O(log(n)), while checking a list is O(n). Therefore, to increase performance, this patch changes the check accordingly.

There's a python script which grants permissions to your Dovecot and Postfix
database users.

.. code-block:: console

 user@host:~$ python /path/to/vmm-0.6.0/pgsql/set-permissions.py -h
 Usage: set-permissions.py OPTIONS
 
 Set permissions for Dovecot and Postfix in the vmm database.
 
 Options:
   -h, --help            show this help message and exit
   -a, --askpass         Prompt for the database password.
   -H HOST, --host=HOST  Hostname or IP address of the database server. Leave
                         blank in order to use the default Unix-domain socket.
   -n NAME, --name=NAME  Specifies the name of the database to connect to.
                         Default: mailsys
   -p PASS, --pass=PASS  Password for the database connection.
   -P PORT, --port=PORT  Specifies the TCP port or the local Unix-domain socket
                         file extension on which the server is listening for
                         connections. Default: 5432
   -U USER, --user=USER  Connect to the database as the user USER instead of
                         the default: root
   -D USER, --dovecot=USER
                         Database user name of the Dovecot database user.
                         Default: dovecot
   -M USER, --postfix=USER
                         Database user name of the Postfix (MTA)  database
                         user. Default: postfix
 user@host:~$ python /path/to/vmm-0.6.0/pgsql/set-permissions.py -a -H 127.0.0.1 -U vmm
 Password: 
 user@host:~$