PawelWiki

Below is the list of SQL queries to perform tasks directly on the database. Please note that you should always shut down Confluence & backup your database before performing any of these queries.

select s.SPACEKEY, s.SPACENAME, u.username, u1.first_name, u1.last_name, u1.email_address from SPACES s join SPACEPERMISSIONS p ON s.SPACEID = p.SPACEID join user_mapping u on p.PERMUSERNAME = u.user_key join cwd_user u1 on u.username = u1.user_name where p.PERMTYPE = 'SETSPACEPERMISSIONS';