It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to fix broken permissions on an imported space via SQL when permissions page inaccessible

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:

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?


1 answer

Hi Michael,

what if you deleted the imported space and reimported it under the new permission settings?



Thanks for your suggestion, but since I cannot access the space at all I can't get to the delete space function...  I *should* be able to as a confluence-administrators user, but the import of the cloud space to our server seems to have broken all permissions.  I could delete the space from the database, which is how I probably will have to fix this.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,367 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you