From 6df9a01fd2e2a036fb92e90a45c2640e56aeb990 Mon Sep 17 00:00:00 2001 From: Julien Moutinho Date: Tue, 9 Apr 2013 15:11:43 +0200 Subject: [PATCH] =?utf8?q?Correction=20:=20vm=5Fhosted=20:=20rule=5Fpostgr?= =?utf8?q?esql=5Fconfigure=20:=20permissions=20du=20sch=C3=A9ma=20public?= =?utf8?q?=20.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- vm_hosted | 34 +++++++++++++++++----------------- 1 file changed, 17 insertions(+), 17 deletions(-) diff --git a/vm_hosted b/vm_hosted index df6f6db..c1d4608 100755 --- a/vm_hosted +++ b/vm_hosted @@ -1236,12 +1236,12 @@ rule_postgresql_configure () { # NOTE: supprime l'accès au schéma public depuis public, # de sorte à ce que les différents utilisateurices # ne voient pas leurs bases de données entre-elleux ; - sudo -u postgres psql template1 -a -f - <<-EOF - \set ON_ERROR_STOP on - REVOKE ALL ON DATABASE template1 FROM public; - REVOKE ALL ON SCHEMA public FROM public; - GRANT ALL ON SCHEMA public TO postgres; - EOF + #sudo -u postgres psql template1 -a -f - <<-EOF + # \set ON_ERROR_STOP on + # REVOKE ALL ON DATABASE template1 FROM public; + # REVOKE ALL ON SCHEMA public FROM public; + # GRANT ALL ON SCHEMA public TO postgres; + # EOF # NOTE: ajoute le support de PL/PGSQL s'il ne l'est pas déjà. sudo -u postgres psql template1 -a -f - <<-EOF \set ON_ERROR_STOP on @@ -1268,17 +1268,17 @@ rule_postgresql_configure () { EOF # NOTE: supprime l'accès à la liste des bases données # et utilisateurices depuis public. - sudo -u postgres psql template1 -a -f - <<-EOF - \set ON_ERROR_STOP on - REVOKE ALL ON pg_auth_members FROM public; - REVOKE ALL ON pg_authid FROM public; - REVOKE ALL ON pg_database FROM public; - REVOKE ALL ON pg_group FROM public; - REVOKE ALL ON pg_roles FROM public; - REVOKE ALL ON pg_settings FROM public; - REVOKE ALL ON pg_tablespace FROM public; - REVOKE ALL ON pg_user FROM public; - EOF + #sudo -u postgres psql template1 -a -f - <<-EOF + # \set ON_ERROR_STOP on + # REVOKE ALL ON pg_auth_members FROM public; + # REVOKE ALL ON pg_authid FROM public; + # REVOKE ALL ON pg_database FROM public; + # REVOKE ALL ON pg_group FROM public; + # REVOKE ALL ON pg_roles FROM public; + # REVOKE ALL ON pg_settings FROM public; + # REVOKE ALL ON pg_tablespace FROM public; + # REVOKE ALL ON pg_user FROM public; + # EOF ) ;; esac -- 2.20.1