Mercurial > lada > lada-server
diff db_schema/setup-db.sh @ 1097:186d602e031a
Merged branch schema-update into default.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 14 Oct 2016 18:17:42 +0200 |
| parents | 1d1c50b7a23b |
| children | ea6b062e5305 1bc8ab13e1f7 |
line wrap: on
line diff
--- a/db_schema/setup-db.sh Fri Oct 14 16:11:22 2016 +0200 +++ b/db_schema/setup-db.sh Fri Oct 14 18:17:42 2016 +0200 @@ -65,11 +65,11 @@ psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql echo set grants psql $DB_CONNECT_STRING -d $DB_NAME --command \ - "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; + "GRANT USAGE ON SCHEMA stammdaten, land TO $ROLE_NAME; GRANT USAGE - ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; + ON ALL SEQUENCES IN SCHEMA stammdaten, land TO $ROLE_NAME; GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES - ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" + ON ALL TABLES IN SCHEMA stammdaten, land TO $ROLE_NAME;" if [ "$NO_DATA" != "true" ]; then echo import stammdaten