S
Supabase•6h ago
H

auth.users table has RLS enabled — cannot sign up (500 error)

Hi Supabase team 👋 I’m having a critical issue with my project — all email sign-up requests fail with: 
AuthApiError: Database error saving new user
AuthApiError: Database error saving new user
After checking, I found that auth.users has relrowsecurity = true.
I understand that the auth schema is managed internally, so I cannot disable RLS myself. Could you please help me disable RLS on auth.users and restore the default Auth schema? Environment details: - Project ID: lsjozpktmapfqxqyaarw - Region: ap-northeast-1 (Tokyo) - Platform: Web (React + @supabase/supabase-js@2) - Error appears when calling supabase.auth.signUp() - Error message: AuthApiError: Database error saving new user - SQL check result: 
  select relname, relrowsecurity
  from pg_class c
  join pg_namespace n on n.oid=c.relnamespace
  where n.nspname='auth' and relname='users';
  
  select relname, relrowsecurity
  from pg_class c
  join pg_namespace n on n.oid=c.relnamespace
  where n.nspname='auth' and relname='users';
→ returns true Thank you for your help 🙏
1 Reply
inder
inder•5h ago
It is supposed to have RLS enabled. Check in auth logs. Usually this error occurs when there is a trigger https://supabase.com/dashboard/project/_/logs/auth-logs

Did you find this page helpful?