view db_schema/setup-db.sh @ 758:57d9b125a7c5

Build war file in validator test to turn off the shibboleth filter.
author Raimund Renkert <raimund.renkert@intevation.de>
date Tue, 03 Nov 2015 09:22:38 +0100
parents 0cf9387c8da2
children 9d2070b84238
line wrap: on
line source
#!/bin/sh
DIR=`dirname $0`

ROLE_NAME=lada
ROLE_PW=lada
DB_NAME=lada

psql --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';"
createdb -E UTF-8 $DB_NAME
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;"
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)