Unable to Create Users Manually in Supabase Auth

[skadamcoffee]

Project ID / Name: SKADAM
Description:

Hello Supabase Support Team,

I am experiencing an issue with manual user creation in the built-in Supabase Auth system (auth.users).

Problem Details:

When I attempt to add a user manually via Authentication → Users → + New User, I receive the following error:

Failed to create user: Database error creating new user

I cannot see the “Settings” tab under Authentication in the dashboard, so I am unable to verify or enable email/password sign-ups.

I attempted to run SQL queries suggested online (e.g., update auth.settings set value = 'true' where name = 'allow_email_signup';) but received errors:

ERROR: 42P01: relation "auth.settings" does not exist

I have confirmed that I am logged in as [Owner / Admin] of the project.

Impact:

I am unable to create new users manually for testing and production purposes.

This prevents staff accounts from being added via the dashboard.

Request:

Please advise how I can enable manual user creation for email/password users in my project.

If possible, enable or guide me to enable email/password sign-ups for the dashboard.

Additional Information:

Browser / OS: [chrome/windows11]

Project Plan: [Free]

Any previous changes to Auth settings or RLS: [Optional]

Thank you for your help.

Best regards,

[krishparmar22242]

Solution 1

Go to the very bottom of the left-hand sidebar and click the Settings (Gear Icon). Then, click on Authentication under the "Project Settings" menu. This is where you can enable/disable email signups and confirm providers.

Solution 2 (SQL query failed)

The table auth.settings does not exist in Supabase. Auth configuration is managed by an internal service called GoTrue. You cannot modify auth settings via SQL queries; you must use the Dashboard UI or the Management API.

Solutition 3
Toggle Confirm Email
If you haven't set up a custom email provider yet, manual creation can sometimes time out. In the settings page mentioned in Step 1, try turning OFF "Confirm Email" just for a moment while you add your staff, then turn it back on.

If this helps you get your users created, please consider marking this as the accepted answer so it can help others in the community!

[krishparmar22242]

Most proabably i think this can be the issue

Solution 4 (Fixing the Database Error)

Many developers add a trigger that automatically creates a row in a public.profiles table whenever a new user is added to auth.users.

1. Go to Database > Triggers.
2. Check for any trigger that runs on the auth.users table (usually called something like on_auth_user_created).
3. If you find one, it is likely failing because your profiles table has a missing column, a data type mismatch, or an RLS policy preventing the "New User" from being created.
4. Test: Disable that trigger temporarily and try adding the user via the dashboard again. If it works, you know your trigger code needs to be fixed.
   If this helps you get your users created, please consider marking this as the accepted answer so it can help others in the community