From 9d336344965a337fc027d117c0423d77b0826d57 Mon Sep 17 00:00:00 2001 From: rich Date: Mon, 27 Sep 2004 14:40:26 +0000 Subject: [PATCH] Removed SET AUTHORIZATION statements from SQL. --- cocanwiki.sql | 54 ------------------------------------------------------ 1 file changed, 54 deletions(-) diff --git a/cocanwiki.sql b/cocanwiki.sql index 05c2a43..c1101b2 100644 --- a/cocanwiki.sql +++ b/cocanwiki.sql @@ -5,8 +5,6 @@ SET client_encoding = 'UNICODE'; SET check_function_bodies = false; -SET SESSION AUTHORIZATION 'postgres'; - -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres @@ -17,8 +15,6 @@ REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -SET SESSION AUTHORIZATION 'rich'; - SET search_path = public, pg_catalog; -- @@ -51,8 +47,6 @@ REVOKE ALL ON TABLE pages FROM PUBLIC; GRANT ALL ON TABLE pages TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 38 (OID 536004) -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich @@ -62,8 +56,6 @@ REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC; GRANT ALL ON TABLE pages_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 7 (OID 536021) -- Name: contents; Type: TABLE; Schema: public; Owner: rich @@ -88,8 +80,6 @@ REVOKE ALL ON TABLE contents FROM PUBLIC; GRANT ALL ON TABLE contents TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 39 (OID 536021) -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich @@ -99,8 +89,6 @@ REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC; GRANT ALL ON TABLE contents_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 9 (OID 536371) -- Name: hosts; Type: TABLE; Schema: public; Owner: rich @@ -128,8 +116,6 @@ REVOKE ALL ON TABLE hosts FROM PUBLIC; GRANT ALL ON TABLE hosts TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 40 (OID 536371) -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich @@ -139,8 +125,6 @@ REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC; GRANT ALL ON TABLE hosts_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 11 (OID 536379) -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich @@ -161,8 +145,6 @@ REVOKE ALL ON TABLE hostnames FROM PUBLIC; GRANT ALL ON TABLE hostnames TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 13 (OID 536915) -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich @@ -184,8 +166,6 @@ REVOKE ALL ON TABLE email_notify FROM PUBLIC; GRANT ALL ON TABLE email_notify TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 15 (OID 537151) -- Name: images; Type: TABLE; Schema: public; Owner: rich @@ -221,8 +201,6 @@ REVOKE ALL ON TABLE images FROM PUBLIC; GRANT ALL ON TABLE images TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 41 (OID 537151) -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich @@ -232,8 +210,6 @@ REVOKE ALL ON TABLE images_id_seq FROM PUBLIC; GRANT ALL ON TABLE images_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 17 (OID 537166) -- Name: files; Type: TABLE; Schema: public; Owner: rich @@ -260,8 +236,6 @@ REVOKE ALL ON TABLE files FROM PUBLIC; GRANT ALL ON TABLE files TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 42 (OID 537166) -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich @@ -271,8 +245,6 @@ REVOKE ALL ON TABLE files_id_seq FROM PUBLIC; GRANT ALL ON TABLE files_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 19 (OID 540816) -- Name: users; Type: TABLE; Schema: public; Owner: rich @@ -303,8 +275,6 @@ REVOKE ALL ON TABLE users FROM PUBLIC; GRANT ALL ON TABLE users TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 43 (OID 540816) -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich @@ -314,8 +284,6 @@ REVOKE ALL ON TABLE users_id_seq FROM PUBLIC; GRANT ALL ON TABLE users_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 21 (OID 540832) -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich @@ -336,8 +304,6 @@ REVOKE ALL ON TABLE usercookies FROM PUBLIC; GRANT ALL ON TABLE usercookies TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 23 (OID 540961) -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich @@ -360,8 +326,6 @@ REVOKE ALL ON TABLE sitemenu FROM PUBLIC; GRANT ALL ON TABLE sitemenu TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 25 (OID 542605) -- Name: contacts; Type: TABLE; Schema: public; Owner: rich @@ -384,8 +348,6 @@ REVOKE ALL ON TABLE contacts FROM PUBLIC; GRANT ALL ON TABLE contacts TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 44 (OID 542605) -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich @@ -395,8 +357,6 @@ REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC; GRANT ALL ON TABLE contacts_id_seq TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 27 (OID 542617) -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich @@ -417,8 +377,6 @@ REVOKE ALL ON TABLE contact_emails FROM PUBLIC; GRANT ALL ON TABLE contact_emails TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 29 (OID 543499) -- Name: themes; Type: TABLE; Schema: public; Owner: rich @@ -440,8 +398,6 @@ REVOKE ALL ON TABLE themes FROM PUBLIC; GRANT SELECT ON TABLE themes TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 31 (OID 543592) -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich @@ -462,8 +418,6 @@ REVOKE ALL ON TABLE server_settings FROM PUBLIC; GRANT SELECT ON TABLE server_settings TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 34 (OID 543754) -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich @@ -489,8 +443,6 @@ REVOKE ALL ON TABLE page_emails FROM PUBLIC; GRANT ALL ON TABLE page_emails TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 36 (OID 543785) -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich @@ -515,8 +467,6 @@ REVOKE ALL ON TABLE mailing_lists FROM PUBLIC; GRANT ALL ON TABLE mailing_lists TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 49 (OID 536388) -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich @@ -880,8 +830,6 @@ ALTER TABLE ONLY mailing_lists ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id); -SET SESSION AUTHORIZATION 'postgres'; - -- -- TOC entry 3 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres @@ -890,8 +838,6 @@ SET SESSION AUTHORIZATION 'postgres'; COMMENT ON SCHEMA public IS 'Standard public namespace'; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 32 (OID 543592) -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich -- 1.8.3.1