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

Gabriele Loibichler

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

Stephen Deutsch

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).

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

4. 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);
                                 }
                     });
                   }
                 });
               }
   });

5. Press enter, and you should hopefully see true a bunch of times (or with a high number next to it).  You should be done!