I have a user that is authenticated but can only insert data into a table when the RLS expression is set to true and the target roles are all public. Changing either of these results in an error. The same table works with other clients that have been registered for months. The difference is they are running on supabase python sdk==0.5.3 and the one I am currently trying to get to work is on the newest python one==1.0.3. I can also send the code but it is identical between the two versions. There are policies for inserting updating and selecting, I am also using returning='minimal' and have tried every iteration possible. It seems like the user can't access auth.uid() and doesn't count as authenticated but when getting the session it says it is and checking through the dashboard also proves it is. I have no more ideas how to debug this so any help would be appreciated.
https://cdn.discordapp.com/attachments/1111322380472680578/1111322381277991003/image.png▾
https://cdn.discordapp.com/attachments/1111322380472680578/1111322381693223022/image.png▾
https://cdn.discordapp.com/attachments/1111322380472680578/1111322382062325852/image.png▾