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.
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.
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
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
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG