User still exists after deleting from database
1. Created a user through my Next.js app that uses Stack Auth.
2. Deleted that user manually using
DELETE FROM neon_auth.users_sync WHERE TRUE;
3. It's not possible to re-use that email for a new signup (see screenshot)
The user does not appear anywhere in the dashboard, or when manually selecting from the database, but apparently it still exists somewhere else which prevents re-using the email address.
2 Replies
adverse-sapphire•3mo ago
neon_auth is powered by Stack Auth, the source of truth for users data is on Stack Auth. And users_sync table is synced copy of that. Deleting a user from users_sync will only delete it from this table, leaving the source as is. That is why you are not able to signup again with same user.
You can transfer the ownership of stack auth project to your account (via configuration -> Claim project ) and then delete the user from source as well.eager-peachOP•3mo ago
Got it, thanks! I assumed neon_auth replaces the Stack Auth backend.