update_tables_0.5.x_for_dovecot-1.2.x.pgsql
changeset 126 3643a0777e77
parent 125 988b9a719929
equal deleted inserted replaced
125:988b9a719929 126:3643a0777e77
     8     SELECT local_part || '@' || domain_name.domainname AS "user",
     8     SELECT local_part || '@' || domain_name.domainname AS "user",
     9            passwd AS "password", smtp, pop3, imap, sieve
     9            passwd AS "password", smtp, pop3, imap, sieve
    10       FROM users
    10       FROM users
    11            LEFT JOIN domain_name USING (gid);
    11            LEFT JOIN domain_name USING (gid);
    12 
    12 
    13 -- ---
       
    14 -- Change the user name to the name of your dovecot database user.
       
    15 -- ---
       
    16 GRANT SELECT ON dovecot_password TO dovecot;
       
    17 --                               ---^
       
    18