equal
deleted
inserted
replaced
6 DROP VIEW dovecot_password; |
6 DROP VIEW dovecot_password; |
7 CREATE OR REPLACE VIEW dovecot_password AS |
7 CREATE OR REPLACE VIEW dovecot_password AS |
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 WHERE domain_name.is_primary; |
|
13 |
12 |
14 -- --- |
13 -- --- |
15 -- Change the user name to the name of your dovecot database user. |
14 -- Change the user name to the name of your dovecot database user. |
16 -- --- |
15 -- --- |
17 GRANT SELECT ON dovecot_password TO dovecot; |
16 GRANT SELECT ON dovecot_password TO dovecot; |