News for hackers. Stuff that matters.
Re:How We Turn Authorization Logic into SQL by jansommer on Wednesday November 24, 2021 @05:59AM (#29328794)
The performance hit can be quite big. I had a query that went from 1s to 400ms by disabling RLS. The security policy was a simple where org = abc. When I encounter performance hits like these, I refactor the slow query into a function with SECURITY DEFINER and a huge warning that you're on your own regarding security. Besides that, it's nice not having to worry if your SQL is accessing stuff the current role isn't allowed to see.

There are no comments on this comment yet.