Keep public and internal snippets upon user removal

Description

Currently, Deleting a user has the following effects: All user content like authored issues, snippets, comments will be removed

Proposal

Either keep these or provide a mechanism to attribute them to another user so they don't just vanish upon user removal.

Links / references