# HG changeset patch # User Raimund Renkert # Date 1446214042 -3600 # Node ID 0cf9387c8da2ce3552537afb7024c2e2cd2d22f2 # Parent 37a8f4d157c792571c4ac40e0f8393b5fa9eaa23 Added grant to all sequences. diff -r 37a8f4d157c7 -r 0cf9387c8da2 db_schema/setup-db.sh --- a/db_schema/setup-db.sh Fri Oct 30 15:06:22 2015 +0100 +++ b/db_schema/setup-db.sh Fri Oct 30 15:07:22 2015 +0100 @@ -10,5 +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 + 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;"