Allow certain user with specific UID to have full access to my table

Question

This is my RLS policy but it doesn t work when I submit while in a session of that specific email UID My form doesn t submit anything relate to auth uid hmm I only submit the content Idk if this is the reason why it doesn t work https cdn discordapp com attachments 1111133999436419142 1111133999595794483 image png

Jason Creviston · Answer

What s your use case here Because there s the `service role` key which can be used to create a separate supabase client and that would bypass RLS

Cokaps016 · Answer

I mean it s website for tracking my lifestyle so only I can edit it and edit it on my phone while still show data on page for my friend

Cokaps016 · Answer

service role is usually used for back end so I think it doesn t suit my need

Jason Creviston · Answer

Yeah `service role` should only be used on server side code

Cokaps016 · Answer

So hmm how do I like make this work

Cokaps016 · Answer

I mean a user with a certain on my website should have a full acess edit delete to my database

Jason Creviston · Answer

I assume you re on the right track with the `auth uid ` but I m not an RLS expert

Jason Creviston · Answer

Checkout this thread https discord com channels 839993398554656828 1065676483869286542