Difference between RLS and WHERE condition (e.g. in views)
0
votes
1
answer
125
views
Is there an functional advantage or performance penalty in using RLS on table vs. using a condition on a view of such table (while hiding the table)?
It seems to me, than rather than using RLS on a table, which is later needed in some views anyway, the views can be limited in their where condition, while not granting any direct access to the table.
Is there any general recommendation on where to choose RLS and where NOT to choose RLS in favour of traditional condition?
Asked by YangombiUmpakati
(107 rep)
Sep 6, 2024, 08:20 AM
Last activity: Sep 6, 2024, 08:28 AM
Last activity: Sep 6, 2024, 08:28 AM