3 ms·

Sounds like a security nightmare, highly recommend pairing them with a dedicated security minded person to ensure correct configurations of access control (netw

Sounds like a security nightmare, highly recommend pairing them with a dedicated security minded person to ensure correct configurations of access control (networklayer/hosts, row level, resource denial of service etc) at the very least have a read of https://postgrest.org/en/stable/admin.html https://postgrest.org/en/stable/admin.html

arnsholt 4y ago
The idea is to have the IT folks managing the configuration of both Postgres and PostgRest, the analysis folks will obviously be working in SQL only.
- maerF0x0 4y ago
  > SQL only. I assume you mean readonly SQL then... (perhaps creating views too)