From 91df5969cc2c56d0ddd875b0e381ce4853fd0318 Mon Sep 17 00:00:00 2001
From: Julien Moutinho <julm+burette@autogeree.net>
Date: Tue, 9 Apr 2013 16:58:51 +0200
Subject: [PATCH] Correction : vm_hosted : rule_postgresql_db_add :
 permissions.

---
 vm_hosted | 1 +
 1 file changed, 1 insertion(+)

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
  }
-- 
2.20.1