Maciej Mrowiec wrote:
> I'm working on RBAC implementation over posgresql and I was wondering is there any common technique to
> achieve row level access control ?
>
> So far I'm considering using WITH clause in template like this:
>
> WITH <table_name> AS ( SELECT ..... ) <user_query>;
>
> Which would be just prepended to any specified query.
>
> I'm fairly new to posgresql, recently I was mostly working with mongodb. So I would be glad to get
> some tips :D
I am not sure if I understand your problem correctly,
but if you want to restrict a query to a subset of rows,
You might be better off with a view that has the
security_barrier option set.
That allows the planner to come up with a better plan.
Yours,
Laurenz Albe