Restrict columns with RLS
RLSHi,
Normally I use CLS to restrict columns for the entire authenticated role. However in this case I only want to restrict a column in certain situations, I am however unable to select the old row in RLS like I can with triggers. What is the correct way to do this with RLS, and are the selected columns like title and profile_id the resulting row or just the changes, because if its just the changes I can check if its null instead.
It seems to be the latter in my instance, so just making sure if thats the way to go
Normally I use CLS to restrict columns for the entire authenticated role. However in this case I only want to restrict a column in certain situations, I am however unable to select the old row in RLS like I can with triggers. What is the correct way to do this with RLS, and are the selected columns like title and profile_id the resulting row or just the changes, because if its just the changes I can check if its null instead.
It seems to be the latter in my instance, so just making sure if thats the way to go
