How do I remove a user who has content created

Still need help?

The Atlassian Community is here for you.

Ask the community

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. 

Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.