How do I remove a user who has content created
This is an old article and it is only valid for versions of Confluence prior 5.2.
Purpose
Confluence doesn't allow the removal of user who has created any content. The standard method for removal is described in Removing a User. If you want to delete the content as well, the SQL is described below.
Solution
Locate the content created by the user using the queries:
SELECT * FROM CONTENT WHERE contenttype = 'COMMENT' and creator = '<Username that you wish to remove>'
and
SELECT * FROM CONTENT WHERE contentid IN (
SELECT DISTINCT pageid FROM CONTENT WHERE contenttype = 'COMMENT' and creator = '<Username that you wish to remove>')
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Run the same DELETE commands after verifying the content is indeed content you wish to delete.