How to know which spaces are allowed to visit by user or group easily?

[Joaquín Núñez]

We have similar groups maybe duplicating access to some spaces.

I would like to clean and unify groups but I do not know how which spaces are related to each group.

Is there any option to see easily?

EX. Group xxxxxx: permission access to spaces...... (lis of spaces)

[Srinatha Tondihal]

Hi @Joaquín Núñez ,

Welcome to Atlassian community. 

I hope you have the access to Database. If you have then you can run the following query to fetch group permissions on spaces. 

select s.spacekey, s.spacename, sp.permtype AS "Permission", sp.permgroupname AS "Group"

from spacepermissions sp

    JOIN spaces s on sp.spaceid = s.spaceid

WHERE sp.spaceid in (select spaceid from spaces)

and sp.permgroupname is not null

and sp.permgroupname != ''

I hope the info helps. Have a good day.

Thanks,

Srinath T

[Joaquín Núñez]

Hi Srinatha T

Thanks for the answer. I will check (access to Database)

[Srinatha Tondihal]

@Joaquín Núñez , sure.