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

0 votes
Accepted answer

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 Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,544 views 25 14
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