Using RLS for CLS
Hi,
I wanted to know if it is acceptable to use RLS for CLS.
Basically, I create an UPDATE policy that makes sure other columns remain the same as old record except only allowing 2 certain columns to be different.
In effect, I am enforcing column level security. I do understand the fact that i will have to fetch the row each time I want to update. But this trade-off should be acceptable right?
I wanted to know if it is acceptable to use RLS for CLS.
Basically, I create an UPDATE policy that makes sure other columns remain the same as old record except only allowing 2 certain columns to be different.
In effect, I am enforcing column level security. I do understand the fact that i will have to fetch the row each time I want to update. But this trade-off should be acceptable right?
