How can i display list of space and space details for a user

Roopraj Thapa

Hi, I want to create a macro where the input parameter will be the username and the macro should display all the space to which the user has a permission and the details of the space

Brant Schroeder

@Roopraj Thapa 

There is a SQL query for that https://confluence.atlassian.com/confkb/how-to-list-which-spaces-a-user-can-access-321258272.html

I do not know of a way to get that information through a macro.