4 ms·

> I don’t want to give other teams direct access to a DB [...] You don't have to. Package up necessary queries into views and/or stored procedures and grant pe

by zvrba 4y ago

> I don’t want to give other teams direct access to a DB [...] You don't have to. Package up necessary queries into views and/or stored procedures and grant permissions only on those. Views can also shield from schema changes.

jonhohle 4y ago
That also requires all data to be in the same DB. Often that’s not practical or possible.
- Tostino 4y ago
  Postgres FDW's do wonders to centralize this type of access.
- zvrba 4y ago
  In SQLServer you can define external tables that access data on another server, or even parses a file.