diff schema/install-db.sh @ 247:946baea3d280

Add view to list user profiles with role To be able to GRANT privileges ON ALL TABLES IN SCHEMA, use auth.sql last during database setup.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Jul 2018 19:33:42 +0200
parents 4ebb791b8278
children cc018ad54251
line wrap: on
line diff
--- a/schema/install-db.sh	Thu Jul 26 19:22:07 2018 +0200
+++ b/schema/install-db.sh	Thu Jul 26 19:33:42 2018 +0200
@@ -71,8 +71,11 @@
 
 psql -p "$port" -f "$BASEDIR/roles.sql"
 createdb -p "$port" "$db"
-psql -p "$port" -f "$BASEDIR/gemma.sql" \
-     -f "$BASEDIR/auth.sql" -f "$BASEDIR/manage_users.sql" -d "$db"
+psql -p "$port" -d "$db" \
+     -f "$BASEDIR/gemma.sql" \
+     -f "$BASEDIR/manage_users.sql" \
+     -f "$BASEDIR/auth.sql"
+
 if [[ $demo -eq 1 ]] ; then
   psql -p "$port" -f "$BASEDIR/demo-data/responsibility_areas.sql" \
        -d "$db"