It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is there a way to bulk move users from one group to another?

We recently implemented LDAP and there is significant overlap between our users in the confluence internal directory and our active directory. While we're happy to make the 'switch' and lower the priority of the internal directory below the active directory, this will cause issues as our group names do not match exactly.

For example, we have a group in our internal directory called "staff" which contains all our staff members (as opposed to a group called "client", which contains just about everyone else) but in our active directory, this group is called "all-staff".

When we swap the order of the directories, the "staff" group (that we've applied to just about every space) that we set up will be useless as all our staff users will be in the "all-staff" group.

I have two questions, one of which I hope we can do:

  1. Can we bulk move the active directory users in the "all-staff" group to the "staff" group? OR
  2. Can we bulk change the group permissions (or rename?) the space permissions from "staff" to "all-staff"?


4 answers

1 accepted

There is no pretty way to do this via the UI but I believe we could bulk change the permissiosn via the database. The following SQL would change all permission entries for the group 'staff' and make them for 'all-staff'. Please keep in mind, this would be for ALL permissions that were specific to the 'staff' group across the entire instance of Confluence. Furthermore, I have not tested this against antying other then a small local instance. With that in mind, I highly suggest trying this in a test environment first and be sure to create a backup of the DB first.



P.S make sure Confluence is off when making these changes.

Thanks! I'll try it out.

Reading this question I found some imporvement requests which informs similiar request that are still under analysis:

JIRA Improvement Request portal....where requests go to die. 

1 vote


You could also do it with the Power Scripts for Confluence add-on:

It is a free add-on. Here is the script you need:

string[] users = usersInGroups({"remove group name"});

for(number i = 0; i < size(users); i = i + 1) {
removeUserFromGroup(users[i], "remove group name");
 addUserToGroup(users[i], "add group name");

Hi community, 

Just in case. The one that worked for me was to copy the users from a sql query result and save it as a CSV file, then copy all the users from that CSV and add them to the group from JIRA using the normal procedure.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

3,916 views 15 38
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you