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

          Form Name

            [JPOSERVER-247] Allow sysadmin/admin to access private plans

            Rachel Robins made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 429071 ]
            Benz Kek (Inactive) made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 465485 ]
            Earl McCutcheon made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 452944 ]
            Earl McCutcheon made changes -
            Description Original: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *JIRA Portfolio Server*. Using *JIRA Portfolio Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/JPOCLOUD-247].
              {panel}

            *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.             		New: {panel:bgColor=#e7f4fa}
            *NOTE:* This suggestion is for *JIRA Portfolio Server*. Using *JIRA Portfolio Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/JPOCLOUD-247].
            {panel}
            *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.

            h3. 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
            {code}
            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>);
             {code}
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3346159 ] New: JAC Suggestion Workflow 3 [ 3666280 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Monique Khairuliana (Inactive) made changes -
            Workflow Original: JPOSERVER JPOCLOUD Suggestion Workflow [ 3159299 ] New: JAC Suggestion Workflow [ 3346159 ]
            joe made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]
            joe made changes -
            Fix Version/s New: 3.4.0 [ 87596 ]
            iceman made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 429101 ]
            iceman made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 425031 ]

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

                Created:
                Updated:
                Resolved:
                Archived: