Supabase•4mo ago•

1 reply

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

auth.users

has

relrowsecurity = true

relrowsecurity = true

.
I understand that the

auth

auth

schema is managed internally, so I cannot disable RLS myself.

Could you please help me disable RLS on
auth.users
auth.users
and restore the default Auth schema?

Environment details:
- Project ID:

lsjozpktmapfqxqyaarw

lsjozpktmapfqxqyaarw

- Region:

ap-northeast-1 (Tokyo)

ap-northeast-1 (Tokyo)

- Platform: Web (React + @supabase/supabase-js@2)
- Error appears when calling

supabase.auth.signUp()

supabase.auth.signUp()

- Error message:

AuthApiError: Database error saving new user

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

true

Thank you for your help

Supabase•4mo ago•

1 reply

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

auth.users

has

relrowsecurity = true

relrowsecurity = true

.
I understand that the

auth

auth

lsjozpktmapfqxqyaarw

lsjozpktmapfqxqyaarw

- Region:

ap-northeast-1 (Tokyo)

ap-northeast-1 (Tokyo)

- Platform: Web (React + @supabase/supabase-js@2)
- Error appears when calling

supabase.auth.signUp()

supabase.auth.signUp()

- Error message:

AuthApiError: Database error saving new user

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

true

Thank you for your help

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads