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

Oracle database schema guide set incorrectly

    XMLWordPrintable

Details

    • 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.

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: