I need the ability to delete a user's content/contributions on our company wiki, if they exercise the right and ask for me to do so. Is this possible? I am an administrator will full capabilities.
Confluence doesn't provide the ability to delete content based on the creator. I didn't find a plugin for it, either.
I did test some direct database queries, which can be used if you absolutely must delete all of a user's content. You definitely want to back up the database before running any delete statements!
To find the user's content, first use this query to get the user's key from the user_mapping table. This key is used in the other tables to identify the user:
select username, user_key from user_mapping where lower_username = 'your_user's_name_here'
After you have the key, you can use it to find content from the user:
select c.contenttype, c.title, s.spacekey, c.creator, c.lastmodifier from content as c, spaces as s where c.spaceid = s.spaceid and (c.creator='user_key' or c.lastmodifier='user_key');
I will let you construct the corresponding delete statement based on the provided queries.
This suggestion ticket is worth watching for your use case:
List user's content when warning that user cannot be removed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.