Guys there is a macro what will display all restriction associated with group ??
I mean for example you have a XXX group and type it intro plug in then got reply group XXX has page restriction at following space : ...
Thanks in advice.
Hey @Marcin Wilczynski,
I've wrote simple query that will give you the page title, space name, group name and restriction type that the specific group have in Confluence:
select c.TITLE AS "Page Title", s.SPACENAME as "Space Name", cp.GROUPNAME as "Group Name", cp.CP_TYPE as "Restriction Type" 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 = 'secret-group';
There's a user macro that user @Andrew Frayling wrote that list all the groups of each space and it's permissions:
In confluence, the term, page restriction is meant to say, group x is the one that have "permission" to view and edit this page/space. However if a page don't have any restrictions applied all groups will be shown by that macro. I will try to write down a sql query to show all pages and spaces that have being restricted to a specific group in case no one shows up a better solution.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG