Fixed DB Roles in SQL Server 2005

In this video for beginners Brian covers the fixed database roles available in SQL Server 2005. He covers what permissions are assigned to each fixed database role.

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...

Richard Dugovic on 2/17/2009

Excellent explanation of SQL Server Database Roles ... and the reference to Microsoft's Help documentation is a nice touch!

Lou Gallo on 7/3/2009

Great! Something I should have known but was too lazy to look up, I just guessed from the names. I learned something today.

Dipak Saha on 7/3/2009

Great topic.

Kamen Angelov on 7/4/2009

too fast speaking, has not visual demonstration

Jamshid Nouri on 7/4/2009

excellent demo

Bruce Bealer on 7/9/2009

Very good. Next show examples of using them. What role for what job.

Tim Harms on 7/9/2009

Generally good information to know. I'd like to hear more about some of the SSIS roles that are part of the msdb database.

Narayana on 7/10/2009

Good thanks

Ravi Raj on 6/29/2010

good one

Kevin Conan on 12/12/2011

If a user has db_owner, they by pass all security checks for that database including deny permissions.

John William Shroy on 12/12/2011

As always, VERY GOOD. Straight forward and to the point.

Roxanne Lenahan on 12/12/2011

Very well-communicated!

Oliver wang on 12/20/2011

yes, I have question about the db_denydatareader. Actually We can tick both db_datareader and db_denydatareader, and it seems there is a conflict here.

Fenying Hao on 12/28/2011

speak too fast