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.
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
Thanks. This gives me for each known user which space the user can access. I need the opposite
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.