Update Retrieve JIRA Administrator Doc to Clarify System Administrator Global Permission inserts

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Invalid
    • None
    • Component/s: Documentation - All
    • None

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator

      In the section about "adding groups to the appropriate global permissions" the SQL that is supposed to add the group to the appropriate global permission doesn't actually do that. Here's the code:

      insert into schemepermissions (id, scheme, permission, perm_type, perm_parameter) values (444444,NULL,44,'group','jira-administrators');
      insert into schemepermissions (id, scheme, permission, perm_type, perm_parameter) values (333333,NULL,1,'group','jira-users');
      

      The schemepermissions table doesn't actually grant the global permission for JIRA System Administrators. That permission is actually granted in the globalpermissionentry table. Only performing this insert will grant that global permission:

      INSERT INTO globalpermissionentry(id, permission, group_id) 
      VALUES (444444, 'SYSTEM_ADMIN', 
      'jira-administrators');
      

            Assignee:
            Wazza
            Reporter:
            kitkat (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: