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

This widget could not be displayed.

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

This widget could not be displayed.

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

This widget could not be displayed.

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

This widget could not be displayed.

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
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

468 views 6 6
Join discussion

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