Hi All,
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';
Notes:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Marcin,
There's a user macro that user @Andrew Frayling wrote that list all the groups of each space and it's permissions:
https://answers.atlassian.com/questions/50804/group-permissions-in-confluence?page=1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.