bug(SCIM) : cannot delete user with a team site

[vviers]

Describe the current behavior

The SCIM API implementation in #1199 lets a superadmin (GRIST_DEFAULT_EMAIL) hard-delete a user on the instance via the DELETE /scim/v2/Users/{userId} endpoint.

However, this does not work if the user to be deleted has a team site in addition to his Personnal site. The app returns a 500 internal error.

Steps to reproduce

1. create a user
2. create a team site
3. connect as a superadmin
4. try to delete the user

Describe the expected behavior

Superadmins should be able to delete a user on the instance they manage regardless of whether the user has created a team site or not.

In our context, the expected behavior would be :

• if the user is the only owner of an org, delete the org
• if there are other owners of an org, simply remove the user from the org before deleting the user

Where have you encountered this bug?

• On docs.getgrist.com
• On a self-hosted instance

Instance information (when self-hosting only)

• Grist instance:
  • Version: 1.4.2
  • Installation mode: kubernetes
  • Architecture: multi-workers