Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-37

Remove dbo schema qualifier from installation scripts

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.00-RC2
    • 1.6.00
    • Data, Install
    • None
    • SQLSERVER
    • Rank:
      0|i0013j:

    Description

      Suggest removing and schema qualifiers on SQLSERVER objects inthe installation scripts - leav it to the user to define whether they want to use dbo or another schema.

      For example I have a single SQLSERVER database with multiple schemas (mimicking hte oracle install), I also have to modify the contents of the C_DB_FULLSCHEMA filed in the ***_DB_LOOKUP tables plus ensure the invidual users have access to the schema.

      But removing the dbo qualifier from the install scripts allows the user more flexibility.

      Attachments

        Activity

          People

            mem61 Mike Mendis
            bswilsonb Brian Wilson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: