delete all conflunce users all at once

Hi,

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,

James

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.

Cheers,
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,

Peter

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.id, u.user_name, u.active from cwd_user u
join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
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: https://confluence.atlassian.com/display/DOC/Restoring+Passwords+To+Recover+Admin+User+Rights

Foogie

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Published 8 hours ago in Confluence

Think you know shares vs. @mentions in Confluence? Take this collab quiz.

To anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...

85 views 2 4
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