Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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)

1 answer

0 votes
Srinatha T Atlassian Team Jun 22, 2022

Hi @joaquin_nunez ,

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.
Srinath T

Hi Srinatha T

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

Like Srinatha T likes this
Srinatha T Atlassian Team Jun 22, 2022

@joaquin_nunez , sure. 

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

959 views 15 27
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you