News for hackers. Stuff that matters.
Re:When you browse Instagram and find Tony Abbott's passport... by thdrdt on Wednesday September 16, 2020 @02:55AM (#24490207)
Lately I am thinking about building a framework for web APIs where the database stores the owner, group and other's rights for each entity. The framework will then fetch data based on the user and fills the models based on the rights set for each field.

Exactly for the reason shown in the article.

I believe right now it is still too difficult to do this in any framework. That's why developers take shortcuts and just expose all entity data or just make a mistake and forget about it.

Does anyone know if such a framework already exists? So per field rights, not per entity rights.

Re:When you browse Instagram and find Tony Abbott's passport... by mulmen on Wednesday September 16, 2020 @05:40AM (#24491051)
Take a look at Postgres roles, I think they are similar to what you describe. This should allow you to set row level permissions per user. Not sure how well that scales.

I know postgrest uses it.

https://www.postgresql.org/docs/12/user-manag.html

Re:When you browse Instagram and find Tony Abbott's passport... by efreak on Wednesday September 16, 2020 @01:59PM (#24495329)
I think the Windows registry has this, doesn't it? Not really applicable to this use case, and do far as I know it's world-readable (acls are applied for writing, not reading) but it does have per-key ACLs (not sure about per-field).
Re:When you browse Instagram and find Tony Abbott's passport... by throwawaynothx on Wednesday September 16, 2020 @02:56AM (#24490211)
or... GraphQL.
Re:When you browse Instagram and find Tony Abbott's passport... by thdrdt on Wednesday September 16, 2020 @03:49AM (#24490459)
How does GraphQL fix the problem of showing different fields depending on rights?