2 ms·
>> 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 ques
by nicktrocado92 7y ago
>> 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?
- BenjieGillam 7y agoAbsolutely not, this is a common misconception. Have a read of this: https://learn.graphile.org/docs/PostgreSQL_Row_Level_Security_Infosheet.pdf https://learn.graphile.org/docs/PostgreSQL_Row_Level_Securit...