How to find group usage in Confluence

How do I find where a specific group is used in Confluence? In other words: How do I find which permissions on spaces a specific group has?

In JIRA you can at least see if a group is used within a permission scheme.

Is this also possible in Confluence?

2 answers

1 accepted

This widget could not be displayed.

Hi Marcel,

there is a handy tool that gives you exactly what you are looking for: a central page where you can view the groups and their permissions in all spaces. 

https://marketplace.atlassian.com/plugins/hu.metainf.plugin.confluence.ultimate-permission-manager/server/overview

Tibor

Hi Tibor,

Thanks for the link. It seems that for every feature that is missing in Confluence ( or Jira) an add-on is available. smile

I'll take a look at it but I expected an answer that leads to a "normal"' resolution just by using Confluence. If that is not available, maybe Atlassian can provide it in future releases.

Regards,

Marcel

Hi Marcel,

I understand your point of view, and you are right.

From another perspective though, the vital Marketplace is the power of Atlassian Ecosystem smile

Good luck and let me know you have questions on the above mentioned addon.

Regards,

Tibor

Don't get me wrong. I understand the value of the Atlassian Ecosystem but an add-on should provide additional functionality that is not a basic need for Confluence and which is very helpful for the business (like Tempo Timesheets for Jira).

Managing your groups in a proper way, including the possibility to see what rights these groups have, should be imbedded in the basic installation of Confluence as this is a basic need (IMHO).

Atlassian still has some work to do.

 

@Marcel Plomp sounds like a valid feature request. Sometimes Atlassians see and respond to questions like yours that come through and that may still happen. Another option exists too...

As you probably know, Atlassian has an 'open' feature request system at jira.atlassian.com   You can search to see if an issue similar to yours has been raised and is open (if so, you can watch the issue and vote for it, plus add comments) or create an issue for it.

Good luck, mate!

Hi Tom,

Thanks. I know. smile

I'll take a look., sometime,.....in the future.

Regards,

Marcel.

An alternative is to attempt to remove a group.  It will give you a warning and tell you where it's used.  You can then cancel the remove.

This is a good start, but does not list groups used in page restrictions

I made this to check for page restrictions:

SELECT
    `SPACENAME` as `Space`,
    `TITLE` as `Page`,
    `CP_TYPE` as `Permission`,
    `GROUPNAME` as `Group`
FROM `CONTENT_PERM` cp
INNER JOIN `CONTENT_PERM_SET` cps ON(cp.`CPS_ID` = cps.`ID`)
INNER JOIN `CONTENT` c ON(c.`CONTENTID` = cps.`CONTENT_ID`)
INNER JOIN `SPACES` s ON(c.`SPACEID` = s.`SPACEID`)
WHERE cp.`GROUPNAME` = '<group name>'
GROUP BY cps.`CONTENT_ID`, `SPACENAME`, `TITLE`, `CP_TYPE`, `GROUPNAME`;

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

476 views 6 6
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