I am building a prompt manager tool. After retrieving prompts from supabase , on lovable when user clicks on a certain prompt, I trigger an n8n flow to get prompt details , the supabase query returns no results. But its strange becuase the earlier query on supabase gets all prompts from the table, user has clicked on one of the prompts , I see the id of the record and user id being passed in webhook for teh prompt details query . Note that I have disabled RLS for now. Please see workflow screenshot and code below.
Check the current status of RLS, Confirm that RLS is completely disabled with:
ALTER TABLE public.prompts ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow public select"
ON public.prompts
FOR SELECT
TO anon, authenticated
USING (true);
Thank you , that’s very helpful. I have currently disabled all RLS and updated lovable, to not pass user id , the code node was baking the user id the query parms and so i wasn’t getting any data. At this point, until I’m still testing with a lot of data, I will work with my current hack ( this tool is just built for me). Once I get to a decent point/baseline, I will add that policy. I have already upped my plan to lovable which has slowed down miserably , so has my chatgpt, so have less room for trail and error. But I will bake in the security once functional testing is done. Thank you so much for your solution !!
