From: Julien Moutinho <julm+heureux-cyclage@autogeree.net>
Date: Mon, 26 Aug 2013 20:09:12 +0000 (+0200)
Subject: Correction : openerp_server : permet list_db .
X-Git-Url: https://git.cyclocoop.org/?p=lhc%2Fateliers.git;a=commitdiff_plain;h=cc3cabea7eaf90a5b21e4a41743a2495b68bff8e

Correction : openerp_server : permet list_db .
---

diff --git a/etc/postgresql/9.1/main/pg_hba.conf b/etc/postgresql/9.1/main/pg_hba.conf
index 1a57ba4..58b338a 100644
--- a/etc/postgresql/9.1/main/pg_hba.conf
+++ b/etc/postgresql/9.1/main/pg_hba.conf
@@ -3,4 +3,6 @@ local         all       postgres  peer      map=admin
 local         all       backup    peer
 local         sameuser  all       peer      map=user
 local         samerole  all       peer      map=role
+local         postgres  openerp_lhc_demo    peer
+local         template1 openerp_server_lhc  peer
 hostssl       all       postgres  samehost  cert
diff --git a/etc/sv/openerp_server_lhc/local.sh b/etc/sv/openerp_server_lhc/local.sh
index 9d953ad..ddd4d42 100644
--- a/etc/sv/openerp_server_lhc/local.sh
+++ b/etc/sv/openerp_server_lhc/local.sh
@@ -14,6 +14,13 @@ sudo -u postgres psql -AqtX "$sv" <<-EOF
 	GRANT SELECT ON TABLE  pg_catalog.pg_proc       TO $sv;
 	GRANT SELECT ON TABLE  pg_catalog.pg_type       TO $sv;
 	EOF
+sudo -u postgres psql -AqtX template1 <<-EOF
+	\set ON_ERROR_STOP on
+	GRANT CONNECT ON DATABASE template1                TO $sv;
+	GRANT USAGE   ON SCHEMA   pg_catalog               TO $sv;
+	GRANT SELECT  ON TABLE    pg_catalog.pg_database   TO $sv;
+	GRANT SELECT  ON TABLE    pg_catalog.pg_user       TO $sv;
+	EOF
 
 "$tool"/local/adduser "$sv" \
  --disabled-login \