What is database owner (dbo) in SQL Server 2000?

What is database owner (dbo) in SQL Server 2000?

Rating:

The database owner (dbo) is a user that has implied permissions to perform all activities in a SQL Server 2000 database. Any member of the sysadmin fixed server role is mapped to a special user called dbo inside each database. Also, any object created by any member of the sysadmin fixed server role automatically belongs to dbo.

For example, if user Mark is a member of the sysadmin fixed server role and creates a table named Tab, the table will belong to dbo and will be qualified as dbo.Tab, not as Mark.Tab. Conversely, if Mark is not a member of the sysadmin fixed server role but is a member of the db_owner fixed database role and creates a table Tab, the table will belong to Mark and will be qualified as Mark.Tab. The table will belong to Mark because he has not qualified the table as dbo.Tab while creating it.

The dbo user cannot be deleted and is always present in every database.

Only objects created by members of the sysadmin fixed server role (or by the dbo user) belong to dbo. Objects created by any other user who is not a member of the sysadmin fixed server role (including members of the db_owner fixed database role) belong to the user creating the object and are qualified with the name of the user who created the object.

Rating: