Why would I use a different table owner other than dbo

[markroworth]

Hi there,

I am trying to understand under what circumstances there would be in using a different table owner other than dbo. My DBA has (it seems arbitrariry) to use different table owners with no real benefit other than it makes. The only effect of it seems to make for longer, harder to read code.

Can anyone give me a brief rundown for common design reasons for it.

Thanks,

Mark

[nbiswas]

In very layman's term

Every object created in SQL SERVER must have an owner. For security reason, it is better to create separate owners for individual databases.e.g. I have created a database that will be exclusively for some selected user group and any other user outside the group will be treated as anonymous and henceforth will not have any grant or permission on that.
In more simpler terms, why we give passwords to our windows login? For security reason. The same concept holds here.

Hope this gives you the basic insight.

For more detailed information, look into

a) Understanding Object Ownership

b) Understanding the Difference between Owners and Schemas in SQL Server