1. I exported a space from our current Confluence Cloud site to import into this Sever site (v 6.12.2). The exported site had the same key ("LUCY") as an existing space on the server site so I had to change it (to "LUCYS")
2. I edited the "entities.xml" file to replace the oldkey with the newkey per the instructions here: https://confluence.atlassian.com/confkb/how-to-copy-or-rename-a-space-in-confluence-169578.html
3. I imported the space as a user with server admin privileges (in group confluence-administrators). However, at the time of import that user was not in "site-admins", the cloud admin group with global access permissions, and that group did not exist yet in the Crowd directory used to authenticate that user). All the user IDs in the server site are, of course, different.
4. I re-indexed the server site.
5. Search found the new space and contents within it BUT the importing, server admin user could not view any of the space contents (pages or attachments). *The permissions page for the imported space also cannot be viewed so permissions cannot be recovered using the Confluence admin pages.*
6. I created "site-admins" group in Crowd and add the importing server admin user to that group. I made sure to sync the directory in Confluence and verified that the user has that group in Confluence. I flushed all caches, rebuilt the ancestor table and re-indexed the site again.
7. The user in site-admins group still cannot see any content in the space and cannot view the space permissions page either.
Since there seems to be no way to fix this from within Confluence I assume it must be fixed by SQL queries to the Confluence database - ? What are the queries I should use and what tables and fields need to be updated, and how, to recover permissions for an admin on the server site so I can then set permissions for the other users?
Thanks!
