4 ms·
You can use row level security so that forgetting the filter isn't an issue.
by latch 6y ago
You can use row level security so that forgetting the filter isn't an issue.
- dorgo 6y agoas far as I understand this would only work for users who don't have access to "deleted" rows. Are access rules a good way to handle this? Serious question. My solution would be to have views as "guards" for every table.
- latch 6y agoViews also work. I don't understand what you mean re "access". RLS is what removes access to those rows, that's the point of RLS. In postgresql, anyways, superusers aren't subject to RLS and the table owner, by default, isn't either. But RLS can be enforced for the table owner by a single alter statement.