DB owner

can there only be one DB owner for a DB or more?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
Only one DBO
But you can have many users with the DB_Owner role
0
 
DarksquireConnect With a Mentor Commented:
The dbo is a user that has implied permissions to perform all activities in the database. Any member of the sysadmin fixed server role who uses a database is mapped to the special user inside each database called dbo. Also, any object created by any member of the sysadmin fixed server role belongs to dbo automatically.

from here:
http://msdn.microsoft.com/en-us/library/aa905208(SQL.80).aspx
0
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
Though there are some applications out there wich checks, and demands that the accunt is the DBO account.

True is that sysadmin users automatically has the DB_Owner role, but the difference between users granted DB_Owner and DBO is that the dbo user cannot be deleted and one DBO is always present in every database.

So if you ask if there can only be one DBO in the database the answer is yes, and furthermore the DBO can not be deleted from the database. Although you can replace the DBO with another account which then becomes the DBO. Any DB_Owner can do this, command: EXEC sp_changedbowner 'DesiredDBOAccount'

Regards Marten
0
 
anushahannaAuthor Commented:
Thanks experts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.