diff db_schema/setup-db.sh @ 1031:2977a7ac414f schema-update

Removed schema bund from setup_db script.
author Raimund Renkert <raimund.renkert@intevation.de>
date Wed, 31 Aug 2016 15:46:59 +0200
parents bc44dcda6f69
children
line wrap: on
line diff
--- a/db_schema/setup-db.sh	Fri Jul 08 15:35:24 2016 +0200
+++ b/db_schema/setup-db.sh	Wed Aug 31 15:46:59 2016 +0200
@@ -65,11 +65,11 @@
 psql $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
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)