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

Oracle database schema guide set incorrectly

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

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

      Support have been seeing a myriad of problems in regards to the schema miconfiguration in getting the creation of sequences right.

      Please see this doco:
      http://confluence.atlassian.com/display/JIRA044/Connecting+JIRA+to+Oracle

      Note that it's missing the full range of permissions that the JIRA 5 doco has:
      http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle

       

grant connect to <user>;
grant create table to <user>;
grant create sequence to <user>;
grant create trigger to <user>;

      AO in GH 5.8.x requires Oracle to have at least sequence creation.

            [JRASERVER-26840] Oracle database schema guide set incorrectly

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3052013 ] New: JAC Suggestion Workflow 3 [ 3680905 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2614702 ] New: JAC Suggestion Workflow [ 3052013 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: JIRA PM Feature Request Workflow v2 - TEMP [ 2578987 ] New: Confluence Workflow - Public Facing v4 [ 2614702 ]
            Status Original: Closed [ 6 ] New: Resolved [ 5 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2358046 ] New: JIRA PM Feature Request Workflow v2 - TEMP [ 2578987 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 2125440 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2358046 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2087907 ] New: JIRA Bug Workflow w Kanban v6 [ 2125440 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 882781 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2087907 ]
            jonah (Inactive) made changes -
            Description Original: Support have been seeing a myriad of problems in regards to the schema miconfiguration in getting the creation of sequences right.

            Please see this doco:
            http://confluence.atlassian.com/display/JIRA044/Connecting+JIRA+to+Oracle

            Note that it's missing the full range of permissions that the JIRA 5 doco has:
            http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle

            {code}

            grant connect to <user>;
            grant create table to <user>;
            grant create sequence to <user>;
            grant create trigger to <user>;
            {code}

            AO in GH 5.8.x requires Oracle to have at least sequence creation.

            		New: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *JIRA Server*. Using *JIRA Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/JRACLOUD-26840].
              {panel}

            Support have been seeing a myriad of problems in regards to the schema miconfiguration in getting the creation of sequences right.

            Please see this doco:
            http://confluence.atlassian.com/display/JIRA044/Connecting+JIRA+to+Oracle

            Note that it's missing the full range of permissions that the JIRA 5 doco has:
            http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle

            {code}

            grant connect to <user>;
            grant create table to <user>;
            grant create sequence to <user>;
            grant create trigger to <user>;
            {code}

            AO in GH 5.8.x requires Oracle to have at least sequence creation.

            jonah (Inactive) made changes -
            Link New: This issue relates to JRACLOUD-26840 [ JRACLOUD-26840 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels New: affects-server

              ggaskell Giles Gaskell [Atlassian]
              mandreacchio Michael Andreacchio
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: