Correction : vm_hosted : rule_postgresql_db_add : permissions.

[lhc/ateliers.git] / vm_hosted

diff --git a/vm_hosted b/vm_hosted
index c1d4608..ff2ade9 100755 (executable)
--- 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
  }