Creating and Using Database Roles in SQL Server

In this video Brian takes you through creating database roles and reasons to use roles in SQL Server. He also goes over assigning permissions to roles.

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

Greg Goodall on 3/16/2009

too much concept and too little visual instruction

John O'Sullivan on 4/16/2009

another good video

Purushtham Kumar katakam on 6/2/2009

good

James Young on 6/2/2009

Thank you for these training snipets they are very useful to me as I have no training in SQL Server and am learning on my own via what is available the web. Regards James Young

Christian Bahnsen on 6/2/2009

These daily videos are invaluable; a great lesson presented short and sweet.

James on 6/2/2009

Good, but would have liked to see more visual instruction put to use in the database.

Tim Mitchell on 6/3/2009

Good explanation of using roles.

Ravi Raj on 6/26/2010

excellent article

J on 7/22/2011

Good stuff. Perhaps might be further helpful of mentioning multiple conflicting permissions & which permissions takes precedence.

León Carpay on 10/19/2011

clear video on basic security setup

Charlie Bruno on 10/19/2011

Very good presentation!

Mark Horninger on 10/19/2011

Great Job Brian!

Terrilyn Sinclair on 10/19/2011

poor sound quality

Kelvin Sammy on 10/19/2011

it was basically an audio lesson. no visual reinforcement of the points being made.

Thirunavukkarasu on 10/20/2011

nice

Tim Curtin on 10/24/2011

the video was fine. The little "Test" at the end was awful. The presenter indeed said that Roles can be nested. So, #begin correct is indeed WRONG. Bad test...

goutham on 12/22/2011

nice video for starter