How to get the table to find out permission of a space in confluence ?

[Vinod Dosemane]

How to get the table to find out permission of a space in confluence ? for e.g who has access to that space? Read/write/admin

[Taranjeet Singh]

@Vinod Dosemane Please use Space Permissions in Confluence as documented here: https://confluence.atlassian.com/doc/space-permissions-overview-139521.html

For Tables in Confluence database, which you can use to get this information, you can refer Confluence Database Schema here: https://confluence.atlassian.com/doc/confluence-data-model-127369837.html, and use the required combination of tables to get information as you need.

This KB article can be very helpful for you if you want to extract permissions information for a Space from Confluence database: https://confluence.atlassian.com/confkb/how-to-check-permissions-for-a-space-via-sql-queries-717062216.html

[Vinod Dosemane]

Hi Taranjeet,

Thanks for your reply.

Space key is comp and spaceid is 16 . How do i put these in the below query and execute?

SELECT sp.permid, sp.permtype, s.spacekey, s.spacename, sp.permgroupname, um.lower_username
FROM SPACEPERMISSIONS sp
JOIN SPACES s ON sp.spaceid = s.spaceid
LEFT JOIN user_mapping um ON sp.permusername = um.user_key
WHERE s.spacekey = '<SPACEKEY>';

[Taranjeet Singh]

@Vinod Dosemane You only need to replace your Space Key i.e. comp, in place of <SPACEKEY> in the above SQL query and then execute this query against your Confluence database. This query should work for PostgreSQL and MySQL, but may require some modification for other databases, if the SQL syntax is different for them.

[Taranjeet Singh]

@Vinod Dosemane Did my answer worked for you? If yes, can you please mark the answer as accepted, for others to follow.

[Taranjeet Singh]

@Vinod Dosemane Did my answer worked for you? If yes, can you please mark the answer as accepted, for others to follow.

[Ryan Fish]

@Vinod Dosemane

As an admin, use space tools located at the bottom left of your page. Then select permissions.
documentation for space permissions.