Jira System Administrators group

[ZipRealty Systems Support]

The local Global Permission group Jira System Administrators is no longer available under the Add Permission drop down.  How do I restore that group to gain access to perform all JIRA administration functions?

[Andy Heinzer]

Hi,

If I understand your problem here, you are in the global permission section of Jira's administration menus, but you no longer see the ability to add a "Jira System Administrator" role to be added.

This happens when your account itself is not currently a System admin.  The fact that you can reach this page means that you must at least be a Jira Administrator.  However Jira admins, that do not have the system admin level permission won't be able to add other groups to that role.  Only users that have the system admin role can do this.  I would suggest reaching out to your Jira system admin to correct this, as this will be the simplest and most straightforward way to adjust this setting. 

If you are certain that you do not have anyone in that role, then I would suggest referring to the guide, Retrieving the JIRA Administrator. It has steps you can follow in order to identify which group(s) are currently system administrators, as well as identify which users are in those groups.  For example, from that guide:

1. To find out which group(s) have been granted the JIRA Administrators global permission, run the following database query:

   select group_id from globalpermissionentry where PERMISSION='ADMINISTER';

2. To find out which group(s) have been granted the JIRA System Administrators global permission, run the following database query:

   select group_id from globalpermissionentry where PERMISSION='SYSTEM_ADMIN';

3. Now that you know which group(s) have the global permission, run the following database query to find out which users are in that group (replace "jira-administrators" with the group returned by the above query):

   select child_name, directory_id from cwd_membership where parent_name='jira-administrators';

There are also steps in that guide for how you can manually adjust SQL to create a new system admin if need be, but I would save these steps as a last resort.  Manually making changes to the SQL database is not something I would suggest lightly, and you should probably create a SQL backup of your database before you go making direct adjustments just in case.

Try these steps, please let me know if you run into any problems with this.

Andy