Re:Row Level Security with PostgreSQL 9.5
by awinter-py on Wednesday April 20, 2016 @04:24PM
(#11537450)
Relying on the PG user/role system doesn't feel general enough to me.
A better solution would set a query on the connection that constrains which rows it can touch. I know this ends up being more complicated and less performant but it splits the difference between app-level and database-enforced security.
A better solution would set a query on the connection that constrains which rows it can touch. I know this ends up being more complicated and less performant but it splits the difference between app-level and database-enforced security.