[CORE-37] Remove dbo schema qualifier from installation scripts Created: 29/Dec/10 Updated: 05/Jun/14 Resolved: 27/Oct/11 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data, Install |
| Affects Version/s: | 1.6.00-RC2 |
| Fix Version/s: | 1.6.00 |
| Type: | Bug | Priority: | Major |
| Reporter: | Brian Wilson | Assignee: | Mike Mendis |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: | SQLSERVER | ||
| Rank: | 0|i0013j: |
| Participant/s: |
| 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. |
| Comments |
| Comment by Mike Mendis [ 27/Oct/11 ] |
|
Was fixed in final version. thanks |