Restore from Backup generated by Cloud wipes out groups with System Administration permission

Robert Wen_ReleaseTEAM_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 11, 2024

I'm in the middle of a Cloud merge migration and I'm using a Jira DC instance I've created as a staging point.

When importing in the Cloud projects to my Jira DC instance, it looks like all groups have been wiped from the System Administration global permission.  I verified using the following SQL:

Screenshot 2024-04-11 at 10.06.29 AM.png

Anyone know the right SQL to add a group back to the System Administration global permission?

3 answers

2 accepted

2 votes
Answer accepted
Gikku
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 11, 2024

@Robert Wen_ReleaseTEAM_  You can use the below 2 queries to modify the permissions.

  1. select * from globalpermissionentry;
  2. update globalpermissionentry set permission = ‘SYSTEM_ADMIN’, group_id = ‘site-admins’ where id = <id>;

Choose any ID from the results of the first query that is not required on your DC instance. Or choose any of the existing ID, use it to grant yourself the system admin rights. I assume you are a site-admin, so you should be a member of the 'site-admins' group imported from Jira. If not, select another that you are added to. 

Once you have the system admin rights, you can add the permission that you modified from the UI.

1 vote
Answer accepted
Robert Wen_ReleaseTEAM_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 12, 2024

Once again, Recovery Mode is my friend.

Once I set the recovery password, the recovery_admin account was able to set everything I needed.

0 votes
Matt Doar April 12, 2024

My handy waving guess is that the export doesn't preserve SYSTEM_ADMIN groups because you could do an import with that and become a sys admin, which is probably only for Atlassians in their Cloud. But it is odd that this hasn't been noted elsewhere, or documented

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
9.12.4
TAGS
AUG Leaders

Atlassian Community Events