Confluence Docs 3.0 : How do I Remove a User who has Content Created This page last changed on Mar 02, 2009 by jlargman. 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. 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>')
Run the same DELETE commands after verifying the content is indeed content you wish to delete.

Document generated by Confluence on Nov 05, 2009 23:34