Automatic provisioning of user :redacted: to app Retool failed: Error while creating user :redacted:: Conflict. Errors reported by remote server: User with that email already exists
I've been told by the Okta admins to delete the user from the app and let Okta assign the user automatically.
Hello there!
You can disable a user by going to your Retool domain, then go into Settings > Users and when seeing the list of users, click on the user you want to disable. You'll see a red text at the bottom of the popup that says "Disable user".
If you have any more questions, please let us know!
Also, don't forget to mark this reply as the answer if it's what you needed
hi @vin,
Unfortunately the only way to properly DELETE a user is by going into your main Retool database that holds all your instance information and running a query to delete them.
Run SELECT * FROM users query, then run a DELETE FROM users WHERE id ={what you found in previous query} . Ensure to have a backup of your DB before doing any DB surgery.
(There is currently a feature ticket to add the ability to delete a user from the UI)
I also need to delete a user as while testing we added a couple that have other retool accounts and everytime they try to login it conflicts with their organization. It's minor, but fairly annoying and inconvenient.
Ah, I see, @the_irav. Sorry, but Cloud customers do not have access to the Retool main storage DB. You will have to access that info via the Retool API. You can read about how to access the Retool API here.
Just tried a simple request but got denied -- Is the API only accessible for enterprise? -
Does this mean I can't delete the user at all unless I fork out some benjamins?
@the_irav,
Sorry, yes, the API is only available to Enterprise customers. You can disable a user, but not delete them. There is a feature request right to our engineering team to give the ability to actually DELETE users rather than just disable them in the UI.
