search

glamod / glamod-ingest

Database preparation and ingestion for GLAMOD
BSD 2-Clause "Simplified" License
2 stars 1 forks source link

Fix the playbook so the web user has read-only access to all the tables in the DB #16

Closed agstephens closed 4 years ago

agstephens commented 4 years ago

Fix the playbook task that should give the "database_web_user" read-only access to all the schemas. When the db is installed you can test it on the test server with (You'll need the password from your vault file):

$  psql -U reader -W cdm

cdm=> select count(*) from full_v2.organisation ;
ERROR:  permission denied for schema full_v2