1.1 --- a/doručenky/dorucenky.pl Wed Nov 30 17:13:26 2011 +0100
1.2 +++ b/doručenky/dorucenky.pl Sat Dec 03 17:54:00 2011 +0100
1.3 @@ -13,6 +13,8 @@
1.4 # viz http://search.cpan.org/~dskoll/MIME-tools-5.502/lib/MIME/Head.pm
1.5 # viz http://perldoc.perl.org/Net/SMTP.html
1.6
1.7 +# aptitude install libmime-tools-perl libmailtools-perl
1.8 +
1.9
1.10 # Nastavení --------------------------------------------------------------------
1.11 my $komu = 'noreply@example.com'; # adresa správce – sem pošleme zprávy, pokud nevíme, kam je poslat (chybí Delivered-To), nebo máme podezření na zacyklení
1.12 @@ -88,3 +90,4 @@
1.13 $dorucenka->print($smtp);
1.14 $smtp->dataend();
1.15 $smtp->quit;
1.16 +
2.1 --- a/sql/schéma.sql Wed Nov 30 17:13:26 2011 +0100
2.2 +++ b/sql/schéma.sql Sat Dec 03 17:54:00 2011 +0100
2.3 @@ -2,8 +2,9 @@
2.4 -- PostgreSQL database dump
2.5 --
2.6
2.7 --- Started on 2009-08-28 17:21:16 CEST
2.8 +-- Started on 2011-12-03 17:50:08 CET
2.9
2.10 +SET statement_timeout = 0;
2.11 SET client_encoding = 'UTF8';
2.12 SET standard_conforming_strings = off;
2.13 SET check_function_bodies = false;
2.14 @@ -11,22 +12,25 @@
2.15 SET escape_string_warning = off;
2.16
2.17 --
2.18 --- TOC entry 8 (class 2615 OID 16387)
2.19 --- Name: posta; Type: SCHEMA; Schema: -; Owner: -
2.20 +-- TOC entry 7 (class 2615 OID 16397)
2.21 +-- Name: posta; Type: SCHEMA; Schema: -; Owner: posta
2.22 --
2.23
2.24 CREATE SCHEMA posta;
2.25
2.26
2.27 +ALTER SCHEMA posta OWNER TO posta;
2.28 +
2.29 SET search_path = posta, pg_catalog;
2.30
2.31 --
2.32 --- TOC entry 57 (class 1255 OID 16694)
2.33 --- Dependencies: 472 8
2.34 --- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: posta; Owner: -
2.35 +-- TOC entry 189 (class 1255 OID 16398)
2.36 +-- Dependencies: 7 551
2.37 +-- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: posta; Owner: posta
2.38 --
2.39
2.40 CREATE FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) RETURNS text
2.41 + LANGUAGE plpgsql SECURITY DEFINER
2.42 AS $$DECLARE pocet integer;
2.43 BEGIN
2.44 UPDATE uzivatel
2.45 @@ -41,14 +45,15 @@
2.46 RAISE EXCEPTION 'Nesprávné heslo, nebo uživatel % neexistuje', "Login" || '@' || "Domena";
2.47 END IF;
2.48 END;
2.49 - $$
2.50 - LANGUAGE plpgsql SECURITY DEFINER;
2.51 + $$;
2.52
2.53
2.54 +ALTER FUNCTION posta.zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) OWNER TO posta;
2.55 +
2.56 --
2.57 --- TOC entry 1981 (class 0 OID 0)
2.58 --- Dependencies: 57
2.59 --- Name: FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying); Type: COMMENT; Schema: posta; Owner: -
2.60 +-- TOC entry 1900 (class 0 OID 0)
2.61 +-- Dependencies: 189
2.62 +-- Name: FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying); Type: COMMENT; Schema: posta; Owner: posta
2.63 --
2.64
2.65 COMMENT ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) IS 'Změní heslo uživatele.';
2.66 @@ -59,9 +64,9 @@
2.67 SET default_with_oids = false;
2.68
2.69 --
2.70 --- TOC entry 1657 (class 1259 OID 16550)
2.71 --- Dependencies: 8
2.72 --- Name: alias; Type: TABLE; Schema: posta; Owner: -; Tablespace:
2.73 +-- TOC entry 143 (class 1259 OID 16399)
2.74 +-- Dependencies: 7
2.75 +-- Name: alias; Type: TABLE; Schema: posta; Owner: posta; Tablespace:
2.76 --
2.77
2.78 CREATE TABLE alias (
2.79 @@ -72,10 +77,12 @@
2.80 );
2.81
2.82
2.83 +ALTER TABLE posta.alias OWNER TO posta;
2.84 +
2.85 --
2.86 --- TOC entry 1983 (class 0 OID 0)
2.87 --- Dependencies: 1657
2.88 --- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: -
2.89 +-- TOC entry 1902 (class 0 OID 0)
2.90 +-- Dependencies: 143
2.91 +-- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: posta
2.92 --
2.93
2.94 COMMENT ON COLUMN alias.zdroj_jmeno IS 'Část zdrojové adresy před zavináčem.
2.95 @@ -83,9 +90,9 @@
2.96
2.97
2.98 --
2.99 --- TOC entry 1984 (class 0 OID 0)
2.100 --- Dependencies: 1657
2.101 --- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: -
2.102 +-- TOC entry 1903 (class 0 OID 0)
2.103 +-- Dependencies: 143
2.104 +-- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: posta
2.105 --
2.106
2.107 COMMENT ON COLUMN alias.zdroj_domena IS 'Část zdrojové adresy za zavináčem.
2.108 @@ -93,9 +100,9 @@
2.109
2.110
2.111 --
2.112 --- TOC entry 1985 (class 0 OID 0)
2.113 --- Dependencies: 1657
2.114 --- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: -
2.115 +-- TOC entry 1904 (class 0 OID 0)
2.116 +-- Dependencies: 143
2.117 +-- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: posta
2.118 --
2.119
2.120 COMMENT ON COLUMN alias.cil_jmeno IS 'Část cílové adresy před zavináčem.
2.121 @@ -103,9 +110,9 @@
2.122
2.123
2.124 --
2.125 --- TOC entry 1986 (class 0 OID 0)
2.126 --- Dependencies: 1657
2.127 --- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: -
2.128 +-- TOC entry 1905 (class 0 OID 0)
2.129 +-- Dependencies: 143
2.130 +-- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: posta
2.131 --
2.132
2.133 COMMENT ON COLUMN alias.cil_domena IS 'Část cílové adresy za zavináčem.
2.134 @@ -113,9 +120,9 @@
2.135
2.136
2.137 --
2.138 --- TOC entry 1644 (class 1259 OID 16396)
2.139 --- Dependencies: 8
2.140 --- Name: domena; Type: TABLE; Schema: posta; Owner: -; Tablespace:
2.141 +-- TOC entry 144 (class 1259 OID 16405)
2.142 +-- Dependencies: 7
2.143 +-- Name: domena; Type: TABLE; Schema: posta; Owner: posta; Tablespace:
2.144 --
2.145
2.146 CREATE TABLE domena (
2.147 @@ -123,63 +130,139 @@
2.148 );
2.149
2.150
2.151 +ALTER TABLE posta.domena OWNER TO posta;
2.152 +
2.153 --
2.154 --- TOC entry 1645 (class 1259 OID 16409)
2.155 --- Dependencies: 8
2.156 --- Name: uzivatel; Type: TABLE; Schema: posta; Owner: -; Tablespace:
2.157 +-- TOC entry 145 (class 1259 OID 16408)
2.158 +-- Dependencies: 1691 7
2.159 +-- Name: alias_externi; Type: VIEW; Schema: posta; Owner: posta
2.160 +--
2.161 +
2.162 +CREATE VIEW alias_externi AS
2.163 + SELECT a.zdroj_jmeno, a.zdroj_domena, a.cil_jmeno, a.cil_domena FROM (alias a LEFT JOIN domena d ON (((a.cil_domena)::text = (d.domena)::text))) WHERE (d.domena IS NULL);
2.164 +
2.165 +
2.166 +ALTER TABLE posta.alias_externi OWNER TO posta;
2.167 +
2.168 +--
2.169 +-- TOC entry 1908 (class 0 OID 0)
2.170 +-- Dependencies: 145
2.171 +-- Name: VIEW alias_externi; Type: COMMENT; Schema: posta; Owner: posta
2.172 +--
2.173 +
2.174 +COMMENT ON VIEW alias_externi IS 'Poštovní alias, který vede na doménu nacházející se na jiném serveru (tzn. e-mail opouští Veverku)';
2.175 +
2.176 +
2.177 +--
2.178 +-- TOC entry 146 (class 1259 OID 16412)
2.179 +-- Dependencies: 1692 7
2.180 +-- Name: alias_interni; Type: VIEW; Schema: posta; Owner: posta
2.181 +--
2.182 +
2.183 +CREATE VIEW alias_interni AS
2.184 + SELECT a.zdroj_jmeno, a.zdroj_domena, a.cil_jmeno, a.cil_domena FROM (alias a LEFT JOIN domena d ON (((a.cil_domena)::text = (d.domena)::text))) WHERE (d.domena IS NOT NULL);
2.185 +
2.186 +
2.187 +ALTER TABLE posta.alias_interni OWNER TO posta;
2.188 +
2.189 +--
2.190 +-- TOC entry 1909 (class 0 OID 0)
2.191 +-- Dependencies: 146
2.192 +-- Name: VIEW alias_interni; Type: COMMENT; Schema: posta; Owner: posta
2.193 +--
2.194 +
2.195 +COMMENT ON VIEW alias_interni IS 'Poštovní alias, který vede na doménu nacházející se na tomto serveru (tzn. e-mail neopouští Veverku)';
2.196 +
2.197 +
2.198 +--
2.199 +-- TOC entry 147 (class 1259 OID 16416)
2.200 +-- Dependencies: 7
2.201 +-- Name: uzivatel; Type: TABLE; Schema: posta; Owner: posta; Tablespace:
2.202 --
2.203
2.204 CREATE TABLE uzivatel (
2.205 login character varying(255) NOT NULL,
2.206 heslo character varying(512),
2.207 - domena character varying(255) NOT NULL
2.208 + domena character varying(255) NOT NULL,
2.209 + jmeno character varying(32)
2.210 );
2.211
2.212
2.213 +ALTER TABLE posta.uzivatel OWNER TO posta;
2.214 +
2.215 --
2.216 --- TOC entry 1658 (class 1259 OID 16602)
2.217 --- Dependencies: 1775 8
2.218 --- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: -
2.219 +-- TOC entry 1910 (class 0 OID 0)
2.220 +-- Dependencies: 147
2.221 +-- Name: COLUMN uzivatel.jmeno; Type: COMMENT; Schema: posta; Owner: posta
2.222 +--
2.223 +
2.224 +COMMENT ON COLUMN uzivatel.jmeno IS 'Celé jméno uživatele';
2.225 +
2.226 +
2.227 +--
2.228 +-- TOC entry 148 (class 1259 OID 16422)
2.229 +-- Dependencies: 1693 7
2.230 +-- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: posta
2.231 --
2.232
2.233 CREATE VIEW dovecot_heslo AS
2.234 SELECT (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS "user", uzivatel.heslo AS password, uzivatel.login, uzivatel.domena FROM uzivatel;
2.235
2.236
2.237 +ALTER TABLE posta.dovecot_heslo OWNER TO posta;
2.238 +
2.239 --
2.240 --- TOC entry 1660 (class 1259 OID 16631)
2.241 --- Dependencies: 1777 8
2.242 --- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: -
2.243 +-- TOC entry 149 (class 1259 OID 16426)
2.244 +-- Dependencies: 1694 7
2.245 +-- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: posta
2.246 --
2.247
2.248 CREATE VIEW dovecot_uzivatel AS
2.249 - SELECT 5000 AS uid, 5000 AS gid, ((('/var/mail/virtualniposta/'::text || (uzivatel.domena)::text) || '/'::text) || (uzivatel.login)::text) AS home, (((('maildir:/var/mail/virtualniposta/'::text || (uzivatel.domena)::text) || '/'::text) || (uzivatel.login)::text) || '/Maildir'::text) AS mail, 'maildir:storage=524288'::text AS quota, uzivatel.login, uzivatel.domena FROM uzivatel;
2.250 + SELECT 5000 AS uid, 5000 AS gid, ((('/var/mail/virtualniposta/'::text || (uzivatel.domena)::text) || '/'::text) || (uzivatel.login)::text) AS home, (((('maildir:/var/mail/virtualniposta/'::text || (uzivatel.domena)::text) || '/'::text) || (uzivatel.login)::text) || '/Maildir'::text) AS mail, 'maildir:Maximalni velikost schranky'::text AS quota, '*:storage=1G'::text AS quota_rule, uzivatel.login, uzivatel.domena FROM uzivatel;
2.251
2.252
2.253 +ALTER TABLE posta.dovecot_uzivatel OWNER TO posta;
2.254 +
2.255 --
2.256 --- TOC entry 1661 (class 1259 OID 16695)
2.257 --- Dependencies: 1778 8
2.258 --- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: -
2.259 +-- TOC entry 150 (class 1259 OID 16430)
2.260 +-- Dependencies: 1695 7
2.261 +-- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: posta
2.262 --
2.263
2.264 CREATE VIEW postfix_alias AS
2.265 SELECT (((alias.zdroj_jmeno)::text || '@'::text) || (alias.zdroj_domena)::text) AS zdroj, (((alias.cil_jmeno)::text || '@'::text) || (alias.cil_domena)::text) AS cil FROM alias;
2.266
2.267
2.268 +ALTER TABLE posta.postfix_alias OWNER TO posta;
2.269 +
2.270 --
2.271 --- TOC entry 1659 (class 1259 OID 16607)
2.272 --- Dependencies: 1776 8
2.273 --- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: -
2.274 +-- TOC entry 151 (class 1259 OID 16434)
2.275 +-- Dependencies: 1696 7
2.276 +-- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: posta
2.277 --
2.278
2.279 CREATE VIEW postfix_uzivatel AS
2.280 SELECT ((((uzivatel.domena)::text || '/'::text) || (uzivatel.login)::text) || '/Maildir/'::text) AS cesta, uzivatel.login, uzivatel.domena FROM uzivatel;
2.281
2.282
2.283 +ALTER TABLE posta.postfix_uzivatel OWNER TO posta;
2.284 +
2.285 --
2.286 --- TOC entry 1975 (class 2606 OID 17071)
2.287 --- Dependencies: 1657 1657 1657 1657 1657
2.288 --- Name: aliasy_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace:
2.289 +-- TOC entry 152 (class 1259 OID 16438)
2.290 +-- Dependencies: 1697 7
2.291 +-- Name: sogo_uzivatel; Type: VIEW; Schema: posta; Owner: posta
2.292 +--
2.293 +
2.294 +CREATE VIEW sogo_uzivatel AS
2.295 + SELECT (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS c_uid, COALESCE((uzivatel.jmeno)::text, (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text)) AS c_cn, (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS c_name, (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS mail, uzivatel.heslo AS c_password FROM uzivatel;
2.296 +
2.297 +
2.298 +ALTER TABLE posta.sogo_uzivatel OWNER TO posta;
2.299 +
2.300 +--
2.301 +-- TOC entry 1890 (class 2606 OID 16443)
2.302 +-- Dependencies: 143 143 143 143 143
2.303 +-- Name: aliasy_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace:
2.304 --
2.305
2.306 ALTER TABLE ONLY alias
2.307 @@ -187,9 +270,9 @@
2.308
2.309
2.310 --
2.311 --- TOC entry 1971 (class 2606 OID 16400)
2.312 --- Dependencies: 1644 1644
2.313 --- Name: domena_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace:
2.314 +-- TOC entry 1892 (class 2606 OID 16445)
2.315 +-- Dependencies: 144 144
2.316 +-- Name: domena_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace:
2.317 --
2.318
2.319 ALTER TABLE ONLY domena
2.320 @@ -197,9 +280,9 @@
2.321
2.322
2.323 --
2.324 --- TOC entry 1973 (class 2606 OID 16416)
2.325 --- Dependencies: 1645 1645 1645
2.326 --- Name: uzivatel_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace:
2.327 +-- TOC entry 1894 (class 2606 OID 16447)
2.328 +-- Dependencies: 147 147 147
2.329 +-- Name: uzivatel_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace:
2.330 --
2.331
2.332 ALTER TABLE ONLY uzivatel
2.333 @@ -207,9 +290,9 @@
2.334
2.335
2.336 --
2.337 --- TOC entry 1977 (class 2606 OID 16558)
2.338 --- Dependencies: 1657 1970 1644
2.339 --- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: -
2.340 +-- TOC entry 1895 (class 2606 OID 16448)
2.341 +-- Dependencies: 143 1891 144
2.342 +-- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: posta
2.343 --
2.344
2.345 ALTER TABLE ONLY alias
2.346 @@ -217,9 +300,9 @@
2.347
2.348
2.349 --
2.350 --- TOC entry 1976 (class 2606 OID 16417)
2.351 --- Dependencies: 1644 1645 1970
2.352 --- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: -
2.353 +-- TOC entry 1896 (class 2606 OID 16453)
2.354 +-- Dependencies: 1891 144 147
2.355 +-- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: posta
2.356 --
2.357
2.358 ALTER TABLE ONLY uzivatel
2.359 @@ -227,9 +310,9 @@
2.360
2.361
2.362 --
2.363 --- TOC entry 1980 (class 0 OID 0)
2.364 --- Dependencies: 8
2.365 --- Name: posta; Type: ACL; Schema: -; Owner: -
2.366 +-- TOC entry 1899 (class 0 OID 0)
2.367 +-- Dependencies: 7
2.368 +-- Name: posta; Type: ACL; Schema: -; Owner: posta
2.369 --
2.370
2.371 REVOKE ALL ON SCHEMA posta FROM PUBLIC;
2.372 @@ -240,9 +323,9 @@
2.373
2.374
2.375 --
2.376 --- TOC entry 1982 (class 0 OID 0)
2.377 --- Dependencies: 57
2.378 --- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: ACL; Schema: posta; Owner: -
2.379 +-- TOC entry 1901 (class 0 OID 0)
2.380 +-- Dependencies: 189
2.381 +-- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: ACL; Schema: posta; Owner: posta
2.382 --
2.383
2.384 REVOKE ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) FROM PUBLIC;
2.385 @@ -253,9 +336,9 @@
2.386
2.387
2.388 --
2.389 --- TOC entry 1987 (class 0 OID 0)
2.390 --- Dependencies: 1657
2.391 --- Name: alias; Type: ACL; Schema: posta; Owner: -
2.392 +-- TOC entry 1906 (class 0 OID 0)
2.393 +-- Dependencies: 143
2.394 +-- Name: alias; Type: ACL; Schema: posta; Owner: posta
2.395 --
2.396
2.397 REVOKE ALL ON TABLE alias FROM PUBLIC;
2.398 @@ -264,9 +347,9 @@
2.399
2.400
2.401 --
2.402 --- TOC entry 1988 (class 0 OID 0)
2.403 --- Dependencies: 1644
2.404 --- Name: domena; Type: ACL; Schema: posta; Owner: -
2.405 +-- TOC entry 1907 (class 0 OID 0)
2.406 +-- Dependencies: 144
2.407 +-- Name: domena; Type: ACL; Schema: posta; Owner: posta
2.408 --
2.409
2.410 REVOKE ALL ON TABLE domena FROM PUBLIC;
2.411 @@ -276,9 +359,9 @@
2.412
2.413
2.414 --
2.415 --- TOC entry 1989 (class 0 OID 0)
2.416 --- Dependencies: 1645
2.417 --- Name: uzivatel; Type: ACL; Schema: posta; Owner: -
2.418 +-- TOC entry 1911 (class 0 OID 0)
2.419 +-- Dependencies: 147
2.420 +-- Name: uzivatel; Type: ACL; Schema: posta; Owner: posta
2.421 --
2.422
2.423 REVOKE ALL ON TABLE uzivatel FROM PUBLIC;
2.424 @@ -288,9 +371,9 @@
2.425
2.426
2.427 --
2.428 --- TOC entry 1990 (class 0 OID 0)
2.429 --- Dependencies: 1658
2.430 --- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: -
2.431 +-- TOC entry 1912 (class 0 OID 0)
2.432 +-- Dependencies: 148
2.433 +-- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: posta
2.434 --
2.435
2.436 REVOKE ALL ON TABLE dovecot_heslo FROM PUBLIC;
2.437 @@ -300,9 +383,9 @@
2.438
2.439
2.440 --
2.441 --- TOC entry 1991 (class 0 OID 0)
2.442 --- Dependencies: 1660
2.443 --- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: -
2.444 +-- TOC entry 1913 (class 0 OID 0)
2.445 +-- Dependencies: 149
2.446 +-- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: posta
2.447 --
2.448
2.449 REVOKE ALL ON TABLE dovecot_uzivatel FROM PUBLIC;
2.450 @@ -312,9 +395,9 @@
2.451
2.452
2.453 --
2.454 --- TOC entry 1992 (class 0 OID 0)
2.455 --- Dependencies: 1661
2.456 --- Name: postfix_alias; Type: ACL; Schema: posta; Owner: -
2.457 +-- TOC entry 1914 (class 0 OID 0)
2.458 +-- Dependencies: 150
2.459 +-- Name: postfix_alias; Type: ACL; Schema: posta; Owner: posta
2.460 --
2.461
2.462 REVOKE ALL ON TABLE postfix_alias FROM PUBLIC;
2.463 @@ -324,9 +407,9 @@
2.464
2.465
2.466 --
2.467 --- TOC entry 1993 (class 0 OID 0)
2.468 --- Dependencies: 1659
2.469 --- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: -
2.470 +-- TOC entry 1915 (class 0 OID 0)
2.471 +-- Dependencies: 151
2.472 +-- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: posta
2.473 --
2.474
2.475 REVOKE ALL ON TABLE postfix_uzivatel FROM PUBLIC;
2.476 @@ -335,7 +418,19 @@
2.477 GRANT SELECT ON TABLE postfix_uzivatel TO posta_cteni;
2.478
2.479
2.480 --- Completed on 2009-08-28 17:21:17 CEST
2.481 +--
2.482 +-- TOC entry 1916 (class 0 OID 0)
2.483 +-- Dependencies: 152
2.484 +-- Name: sogo_uzivatel; Type: ACL; Schema: posta; Owner: posta
2.485 +--
2.486 +
2.487 +REVOKE ALL ON TABLE sogo_uzivatel FROM PUBLIC;
2.488 +REVOKE ALL ON TABLE sogo_uzivatel FROM posta;
2.489 +GRANT ALL ON TABLE sogo_uzivatel TO posta;
2.490 +GRANT SELECT ON TABLE sogo_uzivatel TO posta_cteni;
2.491 +
2.492 +
2.493 +-- Completed on 2011-12-03 17:50:08 CET
2.494
2.495 --
2.496 -- PostgreSQL database dump complete