Recently, we had an employee leave the business. When trying to disable and delete the Confluence account, we have ran into some issues. I am unable to delete the user because: (see screenshot)
We went into the Database and changed all content and last modified fields to my Confluence ID and we delete all drafts (and succesfully disabled the user). This user does not own any spaces within Confluence. However, it does say that the user is an Author of a page in Confluence but we can't find a way to erase or change who authored a page.
I've read a lot of discussion about this but it's kind of ridiculous that administrators can't delete users in a software that we pay for. Is there any database query I can run to completely erase everything a user owns? Any suggestions? Please help.
Believe it is by design that you can only disable and not delete a user that has created content. If you want to go the manual path to changing all created content you could try the steps on this page - https://confluence.atlassian.com/confkb/how-to-change-the-creator-of-a-page-720830744.html?_ga=1.264445775.1711482267.1484079204 and then delete the user.
Vishnukumar and Danny have already said most of what I would normally say.
I just wanted to add "do not edit the database". You've missed things, and it's a nightmare to unpick. You also now have a possibly corrupt and definitely unsupported database.
Just disable the user and move on, it's not worth trying to force a delete this way.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG