Row-Level Security sucks. Can we make it usable?
- Track: PostgreSQL
- Room: UA2.220 (Guillissen)
- Day: Sunday
- Start: 16:00
- End: 16:50
- Video only: ua2220
- Chat: Join the conversation!
Row-Level Security (RLS) in PostgreSQL is awesome, as it allows you to isolate each user or tenant's data, lock it down and default to "deny access"... but it sucks because it makes assumptions about your application that are not applicable in many cases.
Especially if your applications were developed without RLS in mind and you use a single app user to connect to the database, it's impossible to use RLS in any meaningful way.
In this talk, we'll look at possible ways to roll out RLS that can let you take advantage of this powerful feature in the real world.
PostgreSQL Documentation: https://www.postgresql.org/docs/current/ddl-rowsecurity.html
Speakers
Jimmy Angelakos |