X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=vm_hosted;h=ff2ade9f908649769e8433de77aace995d7c1873;hb=91df5969cc2c56d0ddd875b0e381ce4853fd0318;hp=c1d46083160dc666d396e40e45d04b1025abf314;hpb=6df9a01fd2e2a036fb92e90a45c2640e56aeb990;p=lhc%2Fateliers.git

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
  }