-
DataBase Owner
dbo is a user with implicit permissions to perform all activities in the database. Map any members of the fixed server role sysadmin to a special user called dbo within each database. Additionally, any object created by any member of the fixed server role sysadmin automatically belongs to dbo.
For example, if user Andrew is a member of the fixed server role sysadmin and creates table T1, table T1 belongs to dbo and is qualified with dbo.T1 rather than Andrew.T1. Conversely, if Andrew is not a member of the fixed server role sysadmin, but only a member of the fixed database role db_owner, and creates table T1, then T1 belongs to Andrew and is qualified as Andrew.T1. The table belongs to Andrew because the member did not scope the table to dbo.T1.
The dbo user cannot be deleted and this user always appears in every database.
Only objects created by members of the sysadmin fixed server role (or the dbo user) belong to dbo. Objects created by any other user who is not also a member of the syadmin fixed server role (including members of the db_owner fixed database role):
Belongs to the user who created the object, not dbo.
Qualified with the name of the user who created the object.
This article comes from the CSDN blog. Please indicate the source when reprinting: http://blog.csdn.net/zaijiananda/archive/2009/12/21/5047109.aspx