SysAdmin vs DBO vs DB Owner in SQL Server

In this video for beginners Brian covers the difference between the SysAdmin, DBO and DBOwner roles in SQL Server

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Maria Carmen on 7/20/2009

nothing because the video did not work!

Bruce Bealer on 7/20/2009

Could not follow. I may need prior knowledge on security. I know just the basics. Need bigger screen. Don't need to see object explorer. Fill the screen with the query window. I will try watching it a couple more times this week to see if I get a better understanding.

Leonard Peoples on 7/20/2009

No Video. Even after 2nd email today. Please keep trying. I'd love to see this one.

George Squillace on 7/20/2009

I learned something new.

Dinesh Pendlimarri on 7/21/2009

a bit confusing...

Dinesh Pendlimarri on 7/21/2009

a bit confusing...

John Magnabosco on 7/21/2009

Great demo!

Marc Moshman on 7/21/2009

helpful, but still not clear on dbowner vs dbo in other contexts

mark moesch on 7/21/2009

Holy cow, I did not know these things and I do need to know them!

Diana Dee on 7/21/2009

Good information! Once again, much too fast. (Maybe I think it is too fast because I am old.) Slow down! Also, all scripts used in a video should be available via a link on the play page.

Rubens on 7/21/2009

Excellent video, this was extremely useful to me!

Christian Bahnsen on 7/21/2009

Very helpful in pointing out distinctions between these users.

Alex Buttery on 7/21/2009

Very good explanation, it will help me immensely.

eirc on 7/21/2009

very good... excellent.

Christine Adams on 7/21/2009

Good tip. I was unaware of the differences between db_owner and dbo. Thanks for pointing this out.

punjwani on 7/22/2009

Excellent.

995751D667 on 7/22/2009

Talked a little to fast to follow along well.

Orlando on 7/22/2009

interesting distinction between being dbo and being in the db_owner fixed role

mukesh on 7/23/2009

please show a vedio on how to hack a private proxy server. please make it downloded.

K. Brian Kelley on 7/24/2009

Sorry, mukesh, but (a) that doesn't fit based on the content on here and (b) that information is available on the web if you try and look for it.

Thomas Kelley on 7/27/2009

Very good overview, thanks.

Doug Wehmeyer on 7/29/2009

Great talk! It might have been nice to see how to find users mapped to dbo. That seemed emphasized pretty strongly, but with no suggestion to identify if the problem exists.

Anibal on 7/30/2009

Great Example

vin lawrence on 8/1/2009

does what it says on the tin

riya on 8/3/2009

Very good, thanq.

Steve Harris on 8/24/2009

Was complete but still confusing. Maybe show a picture on how the hierarchy looks would be helpful.

aks on 10/26/2009

Good

Chris on 5/1/2010

Excellent. It is just a fact that you cannot limit the privileges of a SysAdmin in SQL Server

Barb Malek on 5/6/2010

The voice was difficult to understand. Faded in and out a bit.

wendy on 10/5/2011

I was puzzled by this for a while. you solve it.

T on 10/19/2011

love it

J on 12/12/2011

Very interesting & helpful. But sounded like you mentioned a few times in referring to the 'db_owner fixed server role' which shouldn't it be referred to on a database level and not server level as 'db_owner database role'?

J on 2/24/2012

learned somthing new also

Janice on 7/12/2012

Very helpful for a non DBA