Database access for user 'matsim'

During the development of the MAS_Interface we introduced the postgres user matsim. This role interacts with the MobilityDatahub and the Rails-related databases during the scenario generation process. Since some schemas / tables which are used for scenario generation are dropped and re-created every month or so, the access privileges for the matsim user have to be set every month. To do so, use: GRANT CONNECT ON DATABASE [database] TO matsim; Specifically, this affects the following objects:

geodata

• schema: osm, tables: osm_germany_point, osm_germany_line, osm_germany_polygon
• schema: gadm, table: districts
• schema: bbsr, table: regiontypes
• schema: zensus2011, table: gitter_100m

population

• schema: bbsrprognose, all tables

surveyed_mobility

• schema: mid2008, tables: cars, households, persons, trips, journeys
• schema: commuters, all tables

shared_mobility

• tables: vehicle_sightings