1.1 --- a/sql/schéma.sql Fri Aug 28 17:24:23 2009 +0200
1.2 +++ b/sql/schéma.sql Sat Dec 03 17:54:00 2011 +0100
1.3 @@ -2,8 +2,9 @@
1.4 -- PostgreSQL database dump
1.5 --
1.6
1.7 --- Started on 2009-08-28 17:21:16 CEST
1.8 +-- Started on 2011-12-03 17:50:08 CET
1.9
1.10 +SET statement_timeout = 0;
1.11 SET client_encoding = 'UTF8';
1.12 SET standard_conforming_strings = off;
1.13 SET check_function_bodies = false;
1.14 @@ -11,22 +12,25 @@
1.15 SET escape_string_warning = off;
1.16
1.17 --
1.18 --- TOC entry 8 (class 2615 OID 16387)
1.19 --- Name: posta; Type: SCHEMA; Schema: -; Owner: -
1.20 +-- TOC entry 7 (class 2615 OID 16397)
1.21 +-- Name: posta; Type: SCHEMA; Schema: -; Owner: posta
1.22 --
1.23
1.24 CREATE SCHEMA posta;
1.25
1.26
1.27 +ALTER SCHEMA posta OWNER TO posta;
1.28 +
1.29 SET search_path = posta, pg_catalog;
1.30
1.31 --
1.32 --- TOC entry 57 (class 1255 OID 16694)
1.33 --- Dependencies: 472 8
1.34 --- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: posta; Owner: -
1.35 +-- TOC entry 189 (class 1255 OID 16398)
1.36 +-- Dependencies: 7 551
1.37 +-- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: posta; Owner: posta
1.38 --
1.39
1.40 CREATE FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) RETURNS text
1.41 + LANGUAGE plpgsql SECURITY DEFINER
1.42 AS $$DECLARE pocet integer;
1.43 BEGIN
1.44 UPDATE uzivatel
1.45 @@ -41,14 +45,15 @@
1.46 RAISE EXCEPTION 'Nesprávné heslo, nebo uživatel % neexistuje', "Login" || '@' || "Domena";
1.47 END IF;
1.48 END;
1.49 - $$
1.50 - LANGUAGE plpgsql SECURITY DEFINER;
1.51 + $$;
1.52
1.53
1.54 +ALTER FUNCTION posta.zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) OWNER TO posta;
1.55 +
1.56 --
1.57 --- TOC entry 1981 (class 0 OID 0)
1.58 --- Dependencies: 57
1.59 --- Name: FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying); Type: COMMENT; Schema: posta; Owner: -
1.60 +-- TOC entry 1900 (class 0 OID 0)
1.61 +-- Dependencies: 189
1.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
1.63 --
1.64
1.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.';
1.66 @@ -59,9 +64,9 @@
1.67 SET default_with_oids = false;
1.68
1.69 --
1.70 --- TOC entry 1657 (class 1259 OID 16550)
1.71 --- Dependencies: 8
1.72 --- Name: alias; Type: TABLE; Schema: posta; Owner: -; Tablespace:
1.73 +-- TOC entry 143 (class 1259 OID 16399)
1.74 +-- Dependencies: 7
1.75 +-- Name: alias; Type: TABLE; Schema: posta; Owner: posta; Tablespace:
1.76 --
1.77
1.78 CREATE TABLE alias (
1.79 @@ -72,10 +77,12 @@
1.80 );
1.81
1.82
1.83 +ALTER TABLE posta.alias OWNER TO posta;
1.84 +
1.85 --
1.86 --- TOC entry 1983 (class 0 OID 0)
1.87 --- Dependencies: 1657
1.88 --- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: -
1.89 +-- TOC entry 1902 (class 0 OID 0)
1.90 +-- Dependencies: 143
1.91 +-- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: posta
1.92 --
1.93
1.94 COMMENT ON COLUMN alias.zdroj_jmeno IS 'Část zdrojové adresy před zavináčem.
1.95 @@ -83,9 +90,9 @@
1.96
1.97
1.98 --
1.99 --- TOC entry 1984 (class 0 OID 0)
1.100 --- Dependencies: 1657
1.101 --- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: -
1.102 +-- TOC entry 1903 (class 0 OID 0)
1.103 +-- Dependencies: 143
1.104 +-- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: posta
1.105 --
1.106
1.107 COMMENT ON COLUMN alias.zdroj_domena IS 'Část zdrojové adresy za zavináčem.
1.108 @@ -93,9 +100,9 @@
1.109
1.110
1.111 --
1.112 --- TOC entry 1985 (class 0 OID 0)
1.113 --- Dependencies: 1657
1.114 --- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: -
1.115 +-- TOC entry 1904 (class 0 OID 0)
1.116 +-- Dependencies: 143
1.117 +-- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: posta
1.118 --
1.119
1.120 COMMENT ON COLUMN alias.cil_jmeno IS 'Část cílové adresy před zavináčem.
1.121 @@ -103,9 +110,9 @@
1.122
1.123
1.124 --
1.125 --- TOC entry 1986 (class 0 OID 0)
1.126 --- Dependencies: 1657
1.127 --- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: -
1.128 +-- TOC entry 1905 (class 0 OID 0)
1.129 +-- Dependencies: 143
1.130 +-- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: posta
1.131 --
1.132
1.133 COMMENT ON COLUMN alias.cil_domena IS 'Část cílové adresy za zavináčem.
1.134 @@ -113,9 +120,9 @@
1.135
1.136
1.137 --
1.138 --- TOC entry 1644 (class 1259 OID 16396)
1.139 --- Dependencies: 8
1.140 --- Name: domena; Type: TABLE; Schema: posta; Owner: -; Tablespace:
1.141 +-- TOC entry 144 (class 1259 OID 16405)
1.142 +-- Dependencies: 7
1.143 +-- Name: domena; Type: TABLE; Schema: posta; Owner: posta; Tablespace:
1.144 --
1.145
1.146 CREATE TABLE domena (
1.147 @@ -123,63 +130,139 @@
1.148 );
1.149
1.150
1.151 +ALTER TABLE posta.domena OWNER TO posta;
1.152 +
1.153 --
1.154 --- TOC entry 1645 (class 1259 OID 16409)
1.155 --- Dependencies: 8
1.156 --- Name: uzivatel; Type: TABLE; Schema: posta; Owner: -; Tablespace:
1.157 +-- TOC entry 145 (class 1259 OID 16408)
1.158 +-- Dependencies: 1691 7
1.159 +-- Name: alias_externi; Type: VIEW; Schema: posta; Owner: posta
1.160 +--
1.161 +
1.162 +CREATE VIEW alias_externi AS
1.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);
1.164 +
1.165 +
1.166 +ALTER TABLE posta.alias_externi OWNER TO posta;
1.167 +
1.168 +--
1.169 +-- TOC entry 1908 (class 0 OID 0)
1.170 +-- Dependencies: 145
1.171 +-- Name: VIEW alias_externi; Type: COMMENT; Schema: posta; Owner: posta
1.172 +--
1.173 +
1.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)';
1.175 +
1.176 +
1.177 +--
1.178 +-- TOC entry 146 (class 1259 OID 16412)
1.179 +-- Dependencies: 1692 7
1.180 +-- Name: alias_interni; Type: VIEW; Schema: posta; Owner: posta
1.181 +--
1.182 +
1.183 +CREATE VIEW alias_interni AS
1.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);
1.185 +
1.186 +
1.187 +ALTER TABLE posta.alias_interni OWNER TO posta;
1.188 +
1.189 +--
1.190 +-- TOC entry 1909 (class 0 OID 0)
1.191 +-- Dependencies: 146
1.192 +-- Name: VIEW alias_interni; Type: COMMENT; Schema: posta; Owner: posta
1.193 +--
1.194 +
1.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)';
1.196 +
1.197 +
1.198 +--
1.199 +-- TOC entry 147 (class 1259 OID 16416)
1.200 +-- Dependencies: 7
1.201 +-- Name: uzivatel; Type: TABLE; Schema: posta; Owner: posta; Tablespace:
1.202 --
1.203
1.204 CREATE TABLE uzivatel (
1.205 login character varying(255) NOT NULL,
1.206 heslo character varying(512),
1.207 - domena character varying(255) NOT NULL
1.208 + domena character varying(255) NOT NULL,
1.209 + jmeno character varying(32)
1.210 );
1.211
1.212
1.213 +ALTER TABLE posta.uzivatel OWNER TO posta;
1.214 +
1.215 --
1.216 --- TOC entry 1658 (class 1259 OID 16602)
1.217 --- Dependencies: 1775 8
1.218 --- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: -
1.219 +-- TOC entry 1910 (class 0 OID 0)
1.220 +-- Dependencies: 147
1.221 +-- Name: COLUMN uzivatel.jmeno; Type: COMMENT; Schema: posta; Owner: posta
1.222 +--
1.223 +
1.224 +COMMENT ON COLUMN uzivatel.jmeno IS 'Celé jméno uživatele';
1.225 +
1.226 +
1.227 +--
1.228 +-- TOC entry 148 (class 1259 OID 16422)
1.229 +-- Dependencies: 1693 7
1.230 +-- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: posta
1.231 --
1.232
1.233 CREATE VIEW dovecot_heslo AS
1.234 SELECT (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS "user", uzivatel.heslo AS password, uzivatel.login, uzivatel.domena FROM uzivatel;
1.235
1.236
1.237 +ALTER TABLE posta.dovecot_heslo OWNER TO posta;
1.238 +
1.239 --
1.240 --- TOC entry 1660 (class 1259 OID 16631)
1.241 --- Dependencies: 1777 8
1.242 --- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: -
1.243 +-- TOC entry 149 (class 1259 OID 16426)
1.244 +-- Dependencies: 1694 7
1.245 +-- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: posta
1.246 --
1.247
1.248 CREATE VIEW dovecot_uzivatel AS
1.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;
1.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;
1.251
1.252
1.253 +ALTER TABLE posta.dovecot_uzivatel OWNER TO posta;
1.254 +
1.255 --
1.256 --- TOC entry 1661 (class 1259 OID 16695)
1.257 --- Dependencies: 1778 8
1.258 --- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: -
1.259 +-- TOC entry 150 (class 1259 OID 16430)
1.260 +-- Dependencies: 1695 7
1.261 +-- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: posta
1.262 --
1.263
1.264 CREATE VIEW postfix_alias AS
1.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;
1.266
1.267
1.268 +ALTER TABLE posta.postfix_alias OWNER TO posta;
1.269 +
1.270 --
1.271 --- TOC entry 1659 (class 1259 OID 16607)
1.272 --- Dependencies: 1776 8
1.273 --- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: -
1.274 +-- TOC entry 151 (class 1259 OID 16434)
1.275 +-- Dependencies: 1696 7
1.276 +-- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: posta
1.277 --
1.278
1.279 CREATE VIEW postfix_uzivatel AS
1.280 SELECT ((((uzivatel.domena)::text || '/'::text) || (uzivatel.login)::text) || '/Maildir/'::text) AS cesta, uzivatel.login, uzivatel.domena FROM uzivatel;
1.281
1.282
1.283 +ALTER TABLE posta.postfix_uzivatel OWNER TO posta;
1.284 +
1.285 --
1.286 --- TOC entry 1975 (class 2606 OID 17071)
1.287 --- Dependencies: 1657 1657 1657 1657 1657
1.288 --- Name: aliasy_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace:
1.289 +-- TOC entry 152 (class 1259 OID 16438)
1.290 +-- Dependencies: 1697 7
1.291 +-- Name: sogo_uzivatel; Type: VIEW; Schema: posta; Owner: posta
1.292 +--
1.293 +
1.294 +CREATE VIEW sogo_uzivatel AS
1.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;
1.296 +
1.297 +
1.298 +ALTER TABLE posta.sogo_uzivatel OWNER TO posta;
1.299 +
1.300 +--
1.301 +-- TOC entry 1890 (class 2606 OID 16443)
1.302 +-- Dependencies: 143 143 143 143 143
1.303 +-- Name: aliasy_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace:
1.304 --
1.305
1.306 ALTER TABLE ONLY alias
1.307 @@ -187,9 +270,9 @@
1.308
1.309
1.310 --
1.311 --- TOC entry 1971 (class 2606 OID 16400)
1.312 --- Dependencies: 1644 1644
1.313 --- Name: domena_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace:
1.314 +-- TOC entry 1892 (class 2606 OID 16445)
1.315 +-- Dependencies: 144 144
1.316 +-- Name: domena_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace:
1.317 --
1.318
1.319 ALTER TABLE ONLY domena
1.320 @@ -197,9 +280,9 @@
1.321
1.322
1.323 --
1.324 --- TOC entry 1973 (class 2606 OID 16416)
1.325 --- Dependencies: 1645 1645 1645
1.326 --- Name: uzivatel_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace:
1.327 +-- TOC entry 1894 (class 2606 OID 16447)
1.328 +-- Dependencies: 147 147 147
1.329 +-- Name: uzivatel_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace:
1.330 --
1.331
1.332 ALTER TABLE ONLY uzivatel
1.333 @@ -207,9 +290,9 @@
1.334
1.335
1.336 --
1.337 --- TOC entry 1977 (class 2606 OID 16558)
1.338 --- Dependencies: 1657 1970 1644
1.339 --- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: -
1.340 +-- TOC entry 1895 (class 2606 OID 16448)
1.341 +-- Dependencies: 143 1891 144
1.342 +-- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: posta
1.343 --
1.344
1.345 ALTER TABLE ONLY alias
1.346 @@ -217,9 +300,9 @@
1.347
1.348
1.349 --
1.350 --- TOC entry 1976 (class 2606 OID 16417)
1.351 --- Dependencies: 1644 1645 1970
1.352 --- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: -
1.353 +-- TOC entry 1896 (class 2606 OID 16453)
1.354 +-- Dependencies: 1891 144 147
1.355 +-- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: posta
1.356 --
1.357
1.358 ALTER TABLE ONLY uzivatel
1.359 @@ -227,9 +310,9 @@
1.360
1.361
1.362 --
1.363 --- TOC entry 1980 (class 0 OID 0)
1.364 --- Dependencies: 8
1.365 --- Name: posta; Type: ACL; Schema: -; Owner: -
1.366 +-- TOC entry 1899 (class 0 OID 0)
1.367 +-- Dependencies: 7
1.368 +-- Name: posta; Type: ACL; Schema: -; Owner: posta
1.369 --
1.370
1.371 REVOKE ALL ON SCHEMA posta FROM PUBLIC;
1.372 @@ -240,9 +323,9 @@
1.373
1.374
1.375 --
1.376 --- TOC entry 1982 (class 0 OID 0)
1.377 --- Dependencies: 57
1.378 --- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: ACL; Schema: posta; Owner: -
1.379 +-- TOC entry 1901 (class 0 OID 0)
1.380 +-- Dependencies: 189
1.381 +-- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: ACL; Schema: posta; Owner: posta
1.382 --
1.383
1.384 REVOKE ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) FROM PUBLIC;
1.385 @@ -253,9 +336,9 @@
1.386
1.387
1.388 --
1.389 --- TOC entry 1987 (class 0 OID 0)
1.390 --- Dependencies: 1657
1.391 --- Name: alias; Type: ACL; Schema: posta; Owner: -
1.392 +-- TOC entry 1906 (class 0 OID 0)
1.393 +-- Dependencies: 143
1.394 +-- Name: alias; Type: ACL; Schema: posta; Owner: posta
1.395 --
1.396
1.397 REVOKE ALL ON TABLE alias FROM PUBLIC;
1.398 @@ -264,9 +347,9 @@
1.399
1.400
1.401 --
1.402 --- TOC entry 1988 (class 0 OID 0)
1.403 --- Dependencies: 1644
1.404 --- Name: domena; Type: ACL; Schema: posta; Owner: -
1.405 +-- TOC entry 1907 (class 0 OID 0)
1.406 +-- Dependencies: 144
1.407 +-- Name: domena; Type: ACL; Schema: posta; Owner: posta
1.408 --
1.409
1.410 REVOKE ALL ON TABLE domena FROM PUBLIC;
1.411 @@ -276,9 +359,9 @@
1.412
1.413
1.414 --
1.415 --- TOC entry 1989 (class 0 OID 0)
1.416 --- Dependencies: 1645
1.417 --- Name: uzivatel; Type: ACL; Schema: posta; Owner: -
1.418 +-- TOC entry 1911 (class 0 OID 0)
1.419 +-- Dependencies: 147
1.420 +-- Name: uzivatel; Type: ACL; Schema: posta; Owner: posta
1.421 --
1.422
1.423 REVOKE ALL ON TABLE uzivatel FROM PUBLIC;
1.424 @@ -288,9 +371,9 @@
1.425
1.426
1.427 --
1.428 --- TOC entry 1990 (class 0 OID 0)
1.429 --- Dependencies: 1658
1.430 --- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: -
1.431 +-- TOC entry 1912 (class 0 OID 0)
1.432 +-- Dependencies: 148
1.433 +-- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: posta
1.434 --
1.435
1.436 REVOKE ALL ON TABLE dovecot_heslo FROM PUBLIC;
1.437 @@ -300,9 +383,9 @@
1.438
1.439
1.440 --
1.441 --- TOC entry 1991 (class 0 OID 0)
1.442 --- Dependencies: 1660
1.443 --- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: -
1.444 +-- TOC entry 1913 (class 0 OID 0)
1.445 +-- Dependencies: 149
1.446 +-- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: posta
1.447 --
1.448
1.449 REVOKE ALL ON TABLE dovecot_uzivatel FROM PUBLIC;
1.450 @@ -312,9 +395,9 @@
1.451
1.452
1.453 --
1.454 --- TOC entry 1992 (class 0 OID 0)
1.455 --- Dependencies: 1661
1.456 --- Name: postfix_alias; Type: ACL; Schema: posta; Owner: -
1.457 +-- TOC entry 1914 (class 0 OID 0)
1.458 +-- Dependencies: 150
1.459 +-- Name: postfix_alias; Type: ACL; Schema: posta; Owner: posta
1.460 --
1.461
1.462 REVOKE ALL ON TABLE postfix_alias FROM PUBLIC;
1.463 @@ -324,9 +407,9 @@
1.464
1.465
1.466 --
1.467 --- TOC entry 1993 (class 0 OID 0)
1.468 --- Dependencies: 1659
1.469 --- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: -
1.470 +-- TOC entry 1915 (class 0 OID 0)
1.471 +-- Dependencies: 151
1.472 +-- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: posta
1.473 --
1.474
1.475 REVOKE ALL ON TABLE postfix_uzivatel FROM PUBLIC;
1.476 @@ -335,7 +418,19 @@
1.477 GRANT SELECT ON TABLE postfix_uzivatel TO posta_cteni;
1.478
1.479
1.480 --- Completed on 2009-08-28 17:21:17 CEST
1.481 +--
1.482 +-- TOC entry 1916 (class 0 OID 0)
1.483 +-- Dependencies: 152
1.484 +-- Name: sogo_uzivatel; Type: ACL; Schema: posta; Owner: posta
1.485 +--
1.486 +
1.487 +REVOKE ALL ON TABLE sogo_uzivatel FROM PUBLIC;
1.488 +REVOKE ALL ON TABLE sogo_uzivatel FROM posta;
1.489 +GRANT ALL ON TABLE sogo_uzivatel TO posta;
1.490 +GRANT SELECT ON TABLE sogo_uzivatel TO posta_cteni;
1.491 +
1.492 +
1.493 +-- Completed on 2011-12-03 17:50:08 CET
1.494
1.495 --
1.496 -- PostgreSQL database dump complete