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

Allow sysadmin/admin to access private plans

    XMLWordPrintable

    Details

    • UIS:
      1,498
    • Support reference count:
      12
    • Feedback Policy:

      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.

      Description

      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>);
       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              akavelar Albert Kavelar
              Votes:
              43 Vote for this issue
              Watchers:
              48 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: