Uploaded image for project: 'Advanced Roadmaps'
  1. Advanced Roadmaps
  2. JPOSERVER-247

Allow sysadmin/admin to access private plans

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • 1,498
    • 12
    • JIRA feedback is collected from a number of different sources and is evaluated when planning the product roadmap. If you would like to know more about how JIRA Product Management uses customer input during the planning process, please see our post on Atlassian Answers.

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

      Summary
      At the moment, sysadmins/admins cannot see a private plan unless they have been explicitly granted access. It would be desirable that admins have access to all plans.

      Use case
      This is to allow sysadmins/admins to see Private Plans for cleaning up purpose, for example when the said use has left the company.

      Workaround:

      You can use the following DB edits, noting these were written in PSQL update per your DB requirements
      Using the Desired plan ID and username insert the 0 and 1 permissions into that plan with the following for the user

      INSERT into "AO_D9132D_PERMISSIONS" VALUES ('<USER NEME HERE>',0,(SELECT max("ID")+1 from "AO_D9132D_PERMISSIONS"),0,<PLAN_ID_HERE>);
      INSERT into "AO_D9132D_PERMISSIONS" VALUES ('<USER NEME HERE>',0,(SELECT max("ID")+1 from "AO_D9132D_PERMISSIONS"),1,<PLAN_ID_HERE>);
       

              Unassigned Unassigned
              akavelar Albert Kavelar
              Archiver:
              atibrewal@atlassian.com Aakrity Tibrewal

                Created:
                Updated:
                Resolved:
                Archived: