> I don’t want to give other teams direct access to a DB [...] You don't have to... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		zvrba on Dec 22, 2022 \| parent \| context \| favorite \| on: For Want of a JOIN > 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 on Dec 22, 2022 [–]

That also requires all data to be in the same DB. Often that’s not practical or possible.

Tostino on Dec 22, 2022 | | [–]

Postgres FDW's do wonders to centralize this type of access.

zvrba on Dec 23, 2022 | | [–]

In SQLServer you can define external tables that access data on another server, or even parses a file.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact