Community
Products
Confluence
Questions
How can I assign a new group permission to all existing spaces in Confluence ?

How can I assign a new group permission to all existing spaces in Confluence ?

Hi,

We have a few hundred spaces, and need permission for a new group for all spaces. Is it possible to do this maybe with an sql-script ?

Changing default permission will only take effect to new spaces, and I really don't want change space permission by "hand" .

I would be glad to get a simple solution.

Gabriele

2 answers

7 votes

You can do this using the Confluence CLI (paid plugin), or you can use this method (I find it works best with the Chrome browser, but Firefox and IE should work too).

Confluence Remote API access should be activated (usually is by default).
You need to be logged in as a Confluence Administrator (a member of "confluence-administrators" group).
Open up the javascript console (usually by pressing F12 and finding "Console" or Ctrl+Shift+J)

Copy/paste the following code, but before copying, change "group_name" to the name of the group you wish to add permissions for, and for each permission you want to add, remove the "//" at the beginning of the line (they correspond from left to right each of the permissions in the Manage Permissions screen):

jQuery.ajax({dataType: 'json',
            contentType: 'application/json',
            type: 'POST',
            url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces',
            success: function( data ) {
              jQuery(data).each(function() {
                if (this.type === "global") {
                  var requestArray = [];
                  var permissionsArray = [];
                  //permissionsArray.push("VIEWSPACE");
                  //permissionsArray.push("EDITSPACE");
                  //permissionsArray.push("EXPORTPAGE");
                  //permissionsArray.push("SETPAGEPERMISSIONS");
                  //permissionsArray.push("REMOVEPAGE");
                  //permissionsArray.push("EDITBLOG");
                  //permissionsArray.push("REMOVEBLOG");
                  //permissionsArray.push("COMMENT");
                  //permissionsArray.push("REMOVECOMMENT");
                  //permissionsArray.push("CREATEATTACHMENT");
                  //permissionsArray.push("REMOVEATTACHMENT");
                  //permissionsArray.push("REMOVEMAIL");
                  //permissionsArray.push("EXPORTSPACE");
                  //permissionsArray.push("SETSPACEPERMISSIONS");
                  requestArray.push(permissionsArray);
                  requestArray.push("group_name");
                  requestArray.push(this.key);
                  jQuery.ajax({dataType: 'json',
                              contentType: 'application/json',
                              type: 'POST',
                              url: contextPath + '/rpc/json-rpc/confluenceservice-v2/addPermissionsToSpace',
                              data: JSON.stringify(requestArray),
                              success: function( data ) {
                                console.log(data);
                              }
                  });
                }
              });
            }
});