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

AuthApiError: Database error saving new user

  select relname, relrowsecurity
  from pg_class c
  join pg_namespace n on n.oid=c.relnamespace
  where n.nspname='auth' and relname='users';