Any user side tool to see which groups have access to which spaces?

Robert Duffer

I need a way to see which spaces or pages a group has access to.  Pretty simple request but can't find anything short of SQL to display this.

Veera_zqt9p1

@Robert Duffer ,

List all the spaces that the group has been granted permissions with the permission type:

<span>SELECT</span> s<span>.</span>SPACEKEY<span>,</span> sp<span>.</span>PERMTYPE <span>as</span> PERMISSIONS
<span>FROM</span> SPACEPERMISSIONS sp
<span>JOIN</span> SPACES s <span>ON</span> s<span>.</span>SPACEID <span>=</span> sp<span>.</span>SPACEID
<span>JOIN</span> cwd_group g <span>ON</span> sp<span>.</span>PERMGROUPNAME <span>=</span> g<span>.</span>group_name
<span>WHERE</span> sp<span>.</span>PERMGROUPNAME <span>IN</span>
<span>(</span>
<span>SELECT</span> g<span>.</span>group_name
<span>FROM</span> cwd_group g
<span>WHERE</span> g<span>.</span>lower_group_name <span>=</span> <span>'<group_name>'</span>
<span>)</span><span>;</span>

List all the pages that the group has been granted view/edit permissions:

select c.contentid, c.title,c.content_status, s.spacekey, s.spacename, cp.groupname, cps.cont_perm_type
from 
content c,
spaces s,
CONTENT_PERM_SET cps,
CONTENT_PERM cp
where
c.contenttype='PAGE'and 
c.spaceid=s.spaceid and
cps.content_id = c.contentid and
cp.cps_id=cps.id and
cp.groupname = '<group name>';