Group for restriction purposes question in Confluence

Dear All,

we met a weird problem: there are a plenty of groups in our Confluence instance which serve only restriction purposes: it means that the group is not assigned to the space's global permission but restricts some pages within the space.

We have a policy that only the admins of a space can ask for group memberships. This is the usual way but in this case there is a problem: we don't know about these restriction groups to which space grant they access.

Is there a script or plugin, feature, etc. with we could see in which space(s) the restriction group is in use?

Thanks in advance,


2 answers

1 accepted

0 votes
Accepted answer

Yes, you can refer to the permgroupname and spaceid columns and see to which spaces the groups have permissions against.

can you please confirm that this table also contains the restriction groups too? Which are not displayed in the Admin->Permissions menu.



Hi Rumi,

You can probably find out to which space this groups have permissions to by querying the database, more precisely in the SPACEPERMISSIONS table.

In addition, if these groups are able to apply restrictions to spaces then they probably have system administrators, which gives them global permissions over all spaces. You can confirm that in the Confluence Admin > Global Permissions section.


From the spacepermissions table we can see where these groups are in use?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

981 views 51 8
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