[fdo][FDO224][New] SqlServer: support tables not owned by dbo

[Brent Robinson]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO224

Type
 Defect

Artifact ID
 FDO224 (SqlServer: support tables not owned by dbo)

Reported by
 Brent Robinson
 brentrobinson (brent.robinson at autodesk.com)

New artifact details:
---------------------------------------------------------

- Platform set to new value
  PC
- Subcomponent set to new value
  SCHEMA
- Artifact Status set to new value
  New
- Description set to new value
  As of Reliant code-complete, the Sql Server provider could not handled tables that were not owned by dbo.
- Version set to new value
  V2
- Operating system set to new value
  Windows XP
- Component set to new value
  RDBMS
- Defect Severity set to new value
  High
- Priority set to new value
  P2
- Artifact created
- Summary set to new value
  SqlServer: support tables not owned by dbo
- Steps to Reproduce set to new value
  You'll need two userids to recreate this bug.

- connected to Sql Server Query Analyzer as user1
- created a database (e.g. db_err).
- went to Sql Server Enterprise Manager and added user2 as a user for the created database
- connected to Sql Server Query Analyzer as user2
- did the following

  use db_err
  create table tab1 ( id bigint, data varchar(10), primary key (id))
  create table user2.tab1 ( id bigint, data smallint, 
      primary key (id))

db_err should now have two tab1 tables, one owned by dbo and the other by user2.

- opened an FDO connection with user2 to the db_err datastore.
- created and executed a DescribeSchema command. Get the following error message:

  Item id is already in this named collection



---------------------------------------------------------
This message was automatically generated by Project Tracker.