1 -- ---

     2 -- with Dovecot v1.2.x the service managesieve was renamed to sieve

     3 -- ---

     4 ALTER TABLE users RENAME managesieve TO sieve;

     5 

     6 DROP VIEW dovecot_password;

     7 CREATE OR REPLACE VIEW dovecot_password AS

     8     SELECT local_part || '@' || domain_name.domainname AS "user",

     9            passwd AS "password", smtp, pop3, imap, sieve

    10       FROM users

    11            LEFT JOIN domain_name USING (gid)

    12      WHERE domain_name.is_primary;

    13 

    14 -- ---

    15 -- Change the user name to the name of your dovecot database user.

    16 -- ---

    17 GRANT SELECT ON dovecot_password TO dovecot;

    18 --                               ---^

    19