Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-41886

Integrity checker detects duplicate permissions on fresh JIRA installation/restoration

    XMLWordPrintable

Details

    Description

      The "Check for Duplicate Permissions" option in the Integrity Checker shows 4 duplicates, even on a fresh installation: DupePerms.jpg

      Checking in the database:

      SELECT * FROM schemepermissions WHERE ID IN (10003, 10032, 10100, 10101);
      

      We get:

      10003		24	group	jira-developers	
      10032		22	group	jira-users	
      10100		33	group	jira-users	
      10101		44	group	jira-administrators	
      

      Clicking on the "Fix" will proceed to delete all the entries above.

      Search for the System Administration global permission group entry:

      select * from schemepermissions where PERMISSION=44;
      

      We received an empty results which mean the JIRA System Administrators global permission group got deleted.

      There are no perceived side effects if I log-in using the JIRA System Administrators user account.

      Additional Notes
      I think it is also worth explaining on why the Integrity Checker manages to find these as "duplicates", when there isn't actually any duplication in the first place. There is only one instance of 22, 24, 33 and 44 permissions in a fresh installation, so there isn't any "duplicates". Also, why does removing them show no side effects even though permission 44 is actually the JIRA System Administrators global permission ?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dleng Daniel Leng (Inactive)
              Votes:
              59 Vote for this issue
              Watchers:
              74 Start watching this issue

              Dates

                Created:
                Updated: