Monday, July 31, 2017

Difference between dbo and db_owner

This question pops up now and then.

dbo is a user and db_owner is a database role. They both are in the Security node in the Object Browser. The SQL Server Management Studio (SSMS) makes it abundantly clear.

dbo


dbo.png

db_owner

db_owner.png

It will be instructive to review their properties as shown here.

dbo - Properties


dboProps.png

db_owner - Properties


db_ownerProps.png

No comments:

Post a Comment

SQL Server 2025 ready to go

 I have not yet done looking at SQL Server 2022, SQL Server 2025 is ready to go. Microsoft is indeed relentless!  Microsoft announced SQL Se...