INF: Inconsistent Behavior with Object Ownership with db_owner Created Objects (306628)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbinfo KB306628
©2003 Microsoft Corporation. All rights reserved.