How to delete users?

[yummyweb]

hey guys, how can i delete users from authentication tab in supabase?

[kiwicopple]

Hey @antriksh123 - we will add a button for this soon, but at the moment you can run this query:

delete from auth.users
where id = THE_USERS_UID

[TechBoyy6]

is there a way to do this with api calls?

[oskarrough]

@TechBoyy6 that's what the last line does for you, the supabaseClient.rpc('my_postgres_function') part. You can wrapit in another API if you like.

[ycagri]

@oskarrough I think you also need to call supabaseClient.auth.signOut(scope: SignOutScope.global) after successful deletion. Otherwise, app goes into a instable state like user does not exists but auth says user is logged in.

[shivpratik]

Will this work with Anon key?

[jacobcoccari]

No, it won't work with the anon key. It needs to be an admin user, which is two levels above. In Supabase, there is anon, authenticated, and admin users.

[MadeByDouglas]

@oskarrough Sorry for the delay; well I'm not sure what to try, thats part of the problem, I just don't understand enough of how these pieces fit together. Is there like a Postgres for beginners course or something really basic that Supabase can provide to front end or mobile devs like myself?

What I think you're saying is, I can write that Postgres query on my Supabase admin panel and then call it from my Swift client to trigger it which will delete the account based on matching the user id from the swift client to whats found on Supabase? So then I just write that as a Postgres query, no edge function needed?

[oskarrough]

There are a lot of parts to understand, for sure.

But yes. Define a Postgres function (via SQL) and call it with supabase.rpc from your app. If you're using swift, see https://supabase.com/docs/reference/swift/rpc

[MadeByDouglas]

Ah ok, this is super helpful! I think I have it sorted now, simpler than I thought now that you've explained it, thanks so much. That documentation link is great as well, thank you.

[k-thornton]

just fyi to anyone stumbling upon this while working with the API:
https://supabase.com/docs/reference/javascript/auth-admin-deleteuser