RLS with a join table
I can't for the life of me figure this one out 
I have a table of for
The
I need to setup RLS so that a user can read, instert, update, or delete a list if they have a
I'm assuming the correct order of operations when creating a new list is:
1. Insert a new row for the list
2. Create the user_list_relation using the list_id from the list that was just created.
But, I'm not sure how this all comes together with RLS.
Let me know what additional info I can provide. Thanks!
I have a table of for
listsuser_list_relationsuser_list_relationslistsThe
user_list_relationsuser_profile_idI need to setup RLS so that a user can read, instert, update, or delete a list if they have a
user_list_relationI'm assuming the correct order of operations when creating a new list is:
1. Insert a new row for the list
2. Create the user_list_relation using the list_id from the list that was just created.
But, I'm not sure how this all comes together with RLS.
Let me know what additional info I can provide. Thanks!
