# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1447236743 -3600
# Node ID 9d2070b84238c00ad18187cfb21704b9c19bfa3f
# Parent  8cf21cd01287ee18eb044154f5b59765903dbe9b
Hibernate needs nextval to insert new datasets.

diff -r 8cf21cd01287 -r 9d2070b84238 db_schema/setup-db.sh
--- a/db_schema/setup-db.sh	Thu Nov 05 10:13:01 2015 +0100
+++ b/db_schema/setup-db.sh	Wed Nov 11 11:12:23 2015 +0100
@@ -10,7 +10,7 @@
 psql -d $DB_NAME -f $DIR/lada_schema.sql
 psql -d $DB_NAME --command \
      "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME;
-      GRANT SELECT
+      GRANT USAGE
             ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;
       GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES
             ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;"