Mercurial > lada > lada-server
changeset 752:0cf9387c8da2
Added grant to all sequences.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 30 Oct 2015 15:07:22 +0100 |
| parents | 37a8f4d157c7 |
| children | 5f6037a281fe |
| files | db_schema/setup-db.sh |
| diffstat | 1 files changed, 2 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- 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;"