RLS One to many relationship
Maybe my brain is just not working correctly. I have done RLS policies for multiple relationships but I am struggling with this specific case. Hopefully someone can point me in the right direction.
I have a table
I want an RLS policy that says a user can delete a row from
Hopefully I explained that well enough, if not I can try to elaborate. Thanks in advanced for any help!
I have a table
shopping_lists which has an owner (user id). I have another table shopping_lists_items which has a shopping_list column that is a foreign key of shopping_lists_items.I want an RLS policy that says a user can delete a row from
shopping_lists_items if it belongs to shopping_lists where the owner is the uid().Hopefully I explained that well enough, if not I can try to elaborate. Thanks in advanced for any help!
