[fdo][FDO224][New] SqlServer: support tables not owned by dbo
Brent Robinson
brent.robinson at autodesk.com
Mon Oct 23 15:31:29 EDT 2006
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.
More information about the Fdo_issues
mailing list