From cc3cabea7eaf90a5b21e4a41743a2495b68bff8e Mon Sep 17 00:00:00 2001 From: Julien Moutinho Date: Mon, 26 Aug 2013 22:09:12 +0200 Subject: [PATCH] Correction : openerp_server : permet list_db . --- etc/postgresql/9.1/main/pg_hba.conf | 2 ++ etc/sv/openerp_server_lhc/local.sh | 7 +++++++ 2 files changed, 9 insertions(+) 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 \ -- 2.20.1