Mercurial > lada > lada-server
diff db_schema/setup-db.sh @ 764:9d2070b84238
Hibernate needs nextval to insert new datasets.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 11 Nov 2015 11:12:23 +0100 |
| parents | 0cf9387c8da2 |
| children | e797391714a0 |
line wrap: on
line diff
--- 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;"