By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 993 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

Why would I use a different table owner other than dbo

P: 2
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.


Dec 3 '09 #1
Share this Question
Share on Google+
1 Reply

P: 149
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
Dec 4 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.