News for hackers. Stuff that matters.

A comment on Ask HN: What are some examples of good database schema designs?. Parent comment

Re:Ask HN: What are some examples of good database schema de... by nicktrocado92 on Friday February 14, 2020 @04:54PM (#22330780)
>> 2. Using PostgreSQL’s “row-level security” system to restrict database results based on the logged in user

I'm interested in PostGraphile, but i have a question: How do apply permissions when your user table is different from postgres user systems? i only have handful of users that have permissions spaning a lot of tables.

Do i need to create one postgres user for each of my application users?

[ Parent | on HN ]
Re:Ask HN: What are some examples of good database schema de... by BenjieGillam on Friday February 14, 2020 @05:42PM (#22331144)
Absolutely not, this is a common misconception. Have a read of this: https://learn.graphile.org/docs/PostgreSQL_Row_Level_Securit...
[ Parent | on HN ]