X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=etc%2Fsv%2Fopenerp_server_lhc%2Flocal.sh;h=ddd4d425763f8be0cd58d8ec1a9b0f2aa0298574;hb=cc3cabea7eaf90a5b21e4a41743a2495b68bff8e;hp=9d953adcce6f1f046d22d1bd477c71992f07e65a;hpb=691dcd533c958c2067b084e453959cb5e6634175;p=lhc%2Fateliers.git

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 \