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_atrole meaning that we need to store those in entity_meta tables with read-only permissions.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?
