Granting Permissions against a Database Object

Granting permissions is a key skill for DBA's, and something that many developers will want to know as well. MVP Brian Kelly demonstrates a couple of the different ways to GRANT permissions - based on users and 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...

Kjell on 5/22/2009

I like these videos where you use the GUI. By scripting tasks you are adressing people that already knows most of the stuff you'll show us. Thanx kjell, Norway

william salkin on 5/25/2009

Interesting but video size could be larger for ease of viewing.

Silpa on 5/26/2009

Helped me.

suvankar on 5/27/2009

great video

Ed Svastits on 5/27/2009

It would have been great to see what SSMS does when a WarehouseSupport user tries to grant himself/herself UPDATE rights to the views.

Amar on 8/8/2009

Nice video for beginners, but could have shown the T-SQL way of doing it too. Cheers!

Charlie Bruno on 3/9/2010

Excellent explanation. Clear, concise and very informative. Nice work.

sandeep2taurus on 11/1/2011

Nice Video

Mark Sedoc on 11/1/2011

In addition maybe set up the script

William on 11/1/2011

Unsure about why I have to click the "add" button to view existing permissions. Still, a great video!

6B2CA9FB1E on 11/1/2011

Expand this to show the SQL which will do the same thing

Vishwanath on 11/1/2011

Gr8 Video and helps a lot for developers.

Craig on 11/1/2011

Thanks Brian, awesome!

John O'Sullivan on 11/1/2011

good tip for Security

Frank on 11/6/2011

fast and good

Thirunavukkarasu on 11/16/2011

nice