How to extract a list of users with (view) access to a confluence space

[Gerard Dens]

I would like to have a list of users with access to a space.

Nicer would be an 'add-on'/macro in the space itself so that the information is always up to date.

[Eduardo Nunes]

Hi Gerard,

You can list which spaces an specific user can access by running the following SQL query against the Confluence database:

  Replace <user_name> with the actual username of the user, in lowercase.

SELECT s.SPACEKEY
FROM SPACEPERMISSIONS sp 
JOIN SPACES s ON s.SPACEID = sp.SPACEID
JOIN user_mapping um ON um.user_key = sp.PERMUSERNAME
WHERE um.lower_username = '<user_name>'
GROUP BY s.SPACEKEY
ORDER BY s.SPACEKEY;

You can see full information in the link below:

https://confluence.atlassian.com/display/CONFKB/How+to+list+which+spaces+a+user+can+access

Cheers,

Enunes

[Gerard Dens]

Thanks. This gives me for each known user which space the user can access. I need the opposite