Unable to Insert Data into Supabase users Table Due to Row Level Security (RLS)
I am experiencing an issue where I cannot insert data into the users table in my Supabase database. The operation fails due to Row Level Security (RLS) being enabled. Although the table structure is correct and the insert query is valid, Supabase returns a permission error indicating that the insert operation is not allowed under the current RLS policy. This is preventing me from creating or registering new data entry in the table through my application.
I suspect that no insert policy has been defined for the users table, or that the existing policy does not allow inserts for the current session role (typically anon or authenticated). I need to correctly define and apply an RLS policy that securely permits user insertion while maintaining proper access control which I think have dont but it doesnot allow entering new data into the table.
The given are my table info and the policy that i have created....
Cronjob timeout
Hi,
I am currently running into timeout issues when doing REFRESH MATERIALIZED VIEW CONCURRENTLY. I have 15 MVs which are called after each other. The cronjob looks like this:
REFRESH MATERIALIZED VIEW CONCURRENTLY mv1;
REFRESH MATERIALIZED VIEW CONCURRENTLY mv2;...
Lost Access to My Supabase Account (GitHub Login Issue)
Hello Supabase Support,
I'm currently unable to access my Supabase account. I used to log in via GitHub, but my GitHub account was recently converted into an organization linked to another GitHub account. Because of this change, I can no longer log in to Supabase using that GitHub identity, as it's now treated as an organization rather than a personal account.
I would appreciate your help in recovering access to my Supabase account. I can provide any necessary information to verify ownership, such as the associated email, project name, or organization details....
Issue with Querying IDs
Currently getting an issue where querying for ids returns newline characters that need to be parsed out. Why?
Set custom owner_id when uploading a file (Supabase Storage)
Is it possible to explicitly set the owner_id field in storage.objects when uploading a file? I need to associate the object with a tenant ID instead of the default user ID.
Using service role in Edge Function
I assumed that using Admin role inside Edge Function was perfectly safe. I was treating it like I was creating a private API route like I usually would in Python. I see no reason why I can't do everything with an admin role, if I am vetting the input data the request receives.
But out of curiosity, I asked claude to review one of my edge functions, and was told I should very rarely use a service role in edge functions. I just can't see why not.
Can someone explain to me why I shouldn't?...
Was email otp expiration limit recently shortened?
Hi, did supabase recently shorten the email otp expiration limit recently? I remember being able to extend it to about 7 days in seconds. Did something change?
what is considered best practice for authenticating an electron app through NextJS+Supabase Auth?
Hey guys, i have a nextJS app that implements supabase auth. I want users in my electron app to be able to press a link, takes them to my website (nextjs app), redirects them back to my app logged in and authenticated. I can't really find the proper docs to do this? I've considered a bunch of stuff like doing an email redirect, deep linking etc. The only thing that worries me is all the talk of PKCE flow, now I can implement a code challenge/verification myself but I haven't done it before and I...
Confused about Edge functions after migrating to JWT Signing Keys
Hi there!
So I just switched to the new JWT Signing Keys and next thing I should disable "Verify JWT with legacy secret" in my Edge Function. But I'm unsure what "OFF with JWT and additional authorization logic implemented inside your function's code." means.
Should I
getUser() inside my function? getClaims()?
Thanks in advance 🙂...Password change in the supabase dashboard
Hello,
Is there a way to change a users password in the supabase dashboard (me as an admin wants to change the users password)?
The user does not have access to his email account anymore and therefore I want to change the users password to log in again and change his email....
Conflicting info about continuous aggregates with timescaledb
Are we able to use this feature or not? I saw posts saying we couldn't because of a licensing issue? Are there any alternatives?
supabase bolt netlify
Can anyone help me with my supabase. I cant seem to let users sign in it just goes back to the homescreen. Im going in circles at this point.
How to authenticate Supabase user inside iframe on a different origin (cross-tab session sharing)
Hi, I want to automatically authenticate the Supabase user inside the iframe, based on the session from the main app.
Invalid access token format. Must be like `sbp_0102
I'm using supabase CLI v 2.33.7 and cant migrate any changes to supabase anymore getting "Invalid access token format. Must be like
sbp_0102...1920." from every angle... how can we use supabase CLI now the service role keys start with eyJ??cron.job_run_details
I see some stats on these in reports > database, they seem to be the stored historical info about cron jobs that have run but where are they kept and how often are they "clearned out" or are they not "cleared out"?
whats happened to Cron editing?
what has happening to the cron editing, you can no longer up date a cron job, with this new "layout", you can gte to the cron edit page, but it wont allow a simple update such as */30 to */15, as wehn you try to save it , it says " A cron job with this name already exists". This used to work find , now it doesnt with this new "layout/ design"
TUS resumable to Storage - strange 404 (works with local supabase) - bucket definitely exists
Hello - I am getting an unexpected 404 using code that was tested with a local supabase setup.
I can confirm that the bucket exists.
I attached the request log from Supabase storage logs.
For the storage policies, they are quite simple for the test, and match the local setup:...
How to solve long latency with Edge Functions?
I'm making an MMO right now that heavily relies on Edge functions for game logic.
Currently my edge functions take ~400-600ms to run even though it's a very small function, and I also see that the edge function keeps shutting down and booting up.
I can't afford to have this latency in production, and was wondering which would be the better solution for me: To upgrade to pro(if that even solves any of the latency issues) or to self host?
I'm not sure if self-hosted supabase has this edge function problem of shutting down/booting up, ideally the edge function server would be online 24/7. I'm also not sure how I would go about replication in future when the time comes to launch my game....
Supabase on DigitalOcean
Hi, I don't get to set up supabase on DO. Every time the CPU spikes to 100% although 2 CPU with 4GB is used. Anyone can help?
Sydney server incident wipes several tables in prod and backup is daily.
Lots of unhappy users. Emailed support 1-2 day response reply. Some tables ok, but several high volume tables have been cleared. Do I wait to restore, hoping the data will return or what? First time experience with something like this. Checked logs, no deletion events associated. Happened when this happened: Aug 1, 2025
Problem with connection pools in ap-southeast-2
Resolved - This incident has been resolved.
Aug 1, 02:43 UTC
Monitoring - We have restarted the affected nodes and will continue monitoring. Postgres clients should reconnect automatically....