Fetch data (through RLS) from unauthenticated context
🟡javascript
RLSauth🟢SQL
RLSauth🟢SQLHello, I am in weird situation where I need to fetch data from a context where I have no authenticated user but the tables have RLS policies which I dont really wanna bypass. Is there really a way to achive this?
Specifically I have a webhook at
In that sync function I read and update from a subscription table which has RLS policied enabled and Im having trouble fetching data. I have assumed that the problem comes down to the fact that because this function is called from an "unauthenticated context" (the webhook), RLS policies fail because there is no auth.id() as the request comes from stripe.
Anyone know the best way to handle this without modifying RLS policies simply for this use-case or even if this is the problem?
EDIT: Going through supabase logs I can see that the relevant requests get 406 - Not Accepted status which I assume is the RLS. Is there a way to go about this?
Specifically I have a webhook at
/src/app/api/stripe/route.tssyncStripeDatatoDB(customerId)/src/lib/stripe/stripe-sync.tsIn that sync function I read and update from a subscription table which has RLS policied enabled and Im having trouble fetching data. I have assumed that the problem comes down to the fact that because this function is called from an "unauthenticated context" (the webhook), RLS policies fail because there is no auth.id() as the request comes from stripe.
Anyone know the best way to handle this without modifying RLS policies simply for this use-case or even if this is the problem?
EDIT: Going through supabase logs I can see that the relevant requests get 406 - Not Accepted status which I assume is the RLS. Is there a way to go about this?
