3.2 - Deleting Users

[Yotouille]

Is your feature request related to a problem? Please describe.
To be able to delete a user we need first to clean all ownership on accounts, then we need to do the same in account history. Only then, the user can be delete without integrity constraint.

We are at the point where we need to delete a user with hundreds of entries. On the account side it seems doable quite easily with the search arguments, but not for "accounts history", there seems to be no argumentation possible there and no details about the "user".

Describe the solution you'd like
At user deletion, there could be an option to transfer ownership to another user (history included !), and a warning to inform about ownership and history lose concerning this user. What do you think ?

Describe alternatives you've considered
We don't delete user and live with it.

Additional context
Error thrown at user deletion:

• When there are accounts owned by the user:
  SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`my_syspass_db`.`Account`, CONSTRAINT `fk_Account_userEditId` FOREIGN KEY (`userEditId`) REFERENCES `User` (`id`))

• When entries exist in the account history (but not in account):
  SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`my_syspass_db`.`AccountHistory`, CONSTRAINT `fk_AccountHistory_userEditId` FOREIGN KEY (`userEditId`) REFERENCES `User` (`id`))

Bye !

[kalypso007]

Hi,
I have the same trouble with 3.2.1 when I try to delete users!
Please made it possible to delete user.

Expected behavior on deleting user:

The GUI should ask which user should inherit the ownership of Accounts and History

In the commits between 3.2.1 and 3.2.11 I do not see changes regarding this behavior.

Kindly regards,
Kalypso

[Arash9703]

Hi,
I also have the same error, and the answer doesn't help.

Kind regards