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
@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
As an admin, use space tools located at the bottom left of your page. Then select permissions.documentation for space permissions.
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_usernameFROM SPACEPERMISSIONS spJOIN SPACES s ON sp.spaceid = s.spaceidLEFT JOIN user_mapping um ON sp.permusername = um.user_keyWHERE s.spacekey = '<SPACEKEY>';
@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.
@Vinod Dosemane Did my answer worked for you? If yes, can you please mark the answer as accepted, for others to follow.
It looks like you're new here. Sign in or register to get started.
