restore deleted user

Question

Hello! I made a REST API call to DELETE a user and the deletion was successful.

1) Is there a way to undelete or restore the deleted user?

2) Are there any time limits before which the deleted user has to be restored?

3) If undelete is not possible, is there a way to transfer the user's data (like leads, opportunities, etc.,) to some other user or an Admin?

I tried making a POST call sending the same details of a deleted user (like id, user_name, first and last_names), but it resulted in an HTTP 500 status. The response payload read something like 'Database failure. Please refer to sugarcrm.log for details.' Is this expected or a bug?

admin guy · Accepted Answer

The log in error message is correct for inactive users trying to log in. Password-entry system must never report to a potential cracker that the username they are trying is valid and they only need to get the password correct! Genuine users will know who to contact if they are unable to get in when they think they should. As for time limits: the User records that are Inactive are still valid and accessible in the GUI so they will not get purged. They can be kept in that state indefinitely if you wish. Sugar records that get deleted have the "deleted" flag set to true. These records are then not available in the GUI, API or any Sugar logic queries that you run (they can still be accessed via any raw SQL that your code writes though). Purging removes these deleted records completely from the database and this is only done via the Scheduler job(s) which the administrator has control of. If you never run the purge job(s) then the deleted record will remain in the database. This may eventually cause problems in terms of available storage so it is a call you have to make as to how much old data you keep that clogs up your available disk space. Thanks, JH.