Microsoft KB Archive/306628

= INF: Inconsistent Behavior with Object Ownership with db_owner Created Objects =

Article ID: 306628

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q306628



SUMMARY
When a user who is a member of the db_owner role in a database creates an object in SQL Enterprise Manager (SEM), the ownership of the object depends on the type of object and the service pack level of the client computer where the object is created.



MORE INFORMATION
If the object (which includes tables, views, stored procedures, and so on) is created on a client computer that has either the released version of the SQL Server 7.0 Enterprise Manager or the 7.0 Service Pack 1 version, the owner of the object will be the user that created the object, not the database owner (DBO).

If a table is created by a member of the db_owner role using SEM from either SQL Server 7.0 Service Pack 2 or 7.0 Service Pack 3, the table will be owned by the DBO. However, any other objects (views, stored procedures, and so on) will be owned by the user creating the object.

This behavior is also seen when creating objects using the SQL Enterprise Manager that is included with the released version of SQL Server 2000 as well as the version included in 2000 Service Pack 1.

To ensure that all objects are owned by the user who creates them, create all objects in Query Analyzer.

Keywords: kbinfo KB306628

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.