Row level security and sorting on foreign tables
So I'm starting my first little project on Supabase and am attempting to remove all need to write CRUD functions bar some more exotic stuff.
The issue with this however is that RLS won't stop a user from updating a column such as
In doing this though we now are unable to perform sorting since sorting on a foreign table value isn't currently supported with PostgREST afaik.
Am I going crazy or is there a better pattern for these things?
The issue with this however is that RLS won't stop a user from updating a column such as
updated_atroleentity_metaIn doing this though we now are unable to perform sorting since sorting on a foreign table value isn't currently supported with PostgREST afaik.
Am I going crazy or is there a better pattern for these things?
