From: Julien Moutinho <julm+burette@autogeree.net>
Date: Tue, 9 Apr 2013 14:58:51 +0000 (+0200)
Subject: Correction : vm_hosted : rule_postgresql_db_add : permissions.
X-Git-Url: https://git.cyclocoop.org/?p=lhc%2Fateliers.git;a=commitdiff_plain;h=91df5969cc2c56d0ddd875b0e381ce4853fd0318

Correction : vm_hosted : rule_postgresql_db_add : permissions.
---

diff --git a/vm_hosted b/vm_hosted
index c1d4608..ff2ade9 100755
--- a/vm_hosted
+++ b/vm_hosted
@@ -1331,6 +1331,7 @@ rule_postgresql_db_add () { # SYNTAX: $db $db_user
 	sudo -u postgres psql template1 -a -f - <<-EOF
 		\set ON_ERROR_STOP on
 		GRANT ${db}_role TO $db_user;
+		ALTER USER $db SET search_path to $db;
 		REVOKE ALL ON DATABASE $db FROM public;
 		EOF
  }