View Ownership Chains

[rebelknight]

In SQL Server 2005 I want to prevent problems with view ownership chains. When two users create views used by a third user, I want to make sure the third user doesn't have to phone up both user 1 and user 2 to get permissions for all views under a view he needs to use.

I know that in SQL Server 2000 you could make all users members of the db_owner role so that 'dbo' could be typed as the owner when creating a view.

In 2005 the owner is no longer part of the object. It is now the schema instead. How can I have users create views and tables and specify the owner to prevent ownership chain problems?

 

[mrdenny]

You can give them rights to the schema you want them to create the objects in.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog