delete all conflunce users all at once


Is there a way to delete all the users in confluence. we have about 500 users and its not gonna be a walk in the park to delete all these.

I do have an access in the database using TOAD.

Thank you,


4 answers

1 accepted

Hi James,

As mentioned by Peter, it is not possible for you to delete all of your users at once, even when you have database access as it tied to Confluence contents. Another possibility is to deactivate users which is possible using the following query:

UPDATE cwd_user SET Active = 'F';

Please make sure that you understand the concecuences of this action as it will set all users to inactive. If you wish to activate your admin, please refer to our documentation here.

Hope it helps.

Septa Cahyadiputra

You might not want to delete all users but rather deactivate them. Deleting a user is only possible if you also delete al his or her content.

Why exactly do you want to delete all users?

Best regards,


Hey James.

You can do so by running these 1 by 1 (Take a DB BACKUP FIRST!):

DELETE FROM cwd_membership;
DELETE FROM cwd_user_attribute;
DELETE FROM cwd_user;

Note that this will remove All Users and only works with Confluence 3.5 and above. It will be great to limit the query with a WHERE clause, to prevent yourself from being locked out of Confluence. The best way would be to run this query:

select, u.user_name, from cwd_user u
join cwd_membership m on join cwd_group g on join cwd_directory d on
where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';

To identify the administrative user's id, then run the queries this way (example if the id is 2818050):

DELETE FROM cwd_membership WHERE child_user_id != 2818050;
DELETE FROM cwd_user_attribute WHERE user_id != 2818050;
DELETE FROM cwd_user WHERE id != 2818050;

Again, this is not recommended by Atlassian. So keep this KB in mind in case you get locked out:


Hi all, Thanks for your comments. I tried the following:

DELETE FROM cwd_membership WHERE child_user_id != user;

DELETE FROM cwd_user_attribute WHERE user_id != user;

DELETE FROM cwd_user WHERE id != user;

it deleted the user in the tables but when i check the user in confluence, it still is there. so i tried restarting the app server and deleting the user manually through administer user page, it just kept loading and loading. same thing happens when i create a user. it seems like i am now not able to create user and remove a user. any suggestion? thanks

ok i managed to fixed this by restoring the site. I think I will just manually remove users from the admin page just to be safe

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

276 views 2 10
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you