Understanding SQL Server Securables

Security in SQL 2005 and beyond includes the concept of securables, allowing the DBA more granularity when assigning permissions. It also means that our old friend sp_helprotect doesn't always return all the information and we need to look to a new resource instead. Presented by MVP Brian Kelley.

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

Prashant Thakwani on 7/28/2009

Great video Brian. Keep uploading the security related videos. I know you have the expertise on that.

Shamshad Ali on 7/28/2009

how to add a user with read only permissions? i need some help on SQL Server 2005 for this purpose. Plz help. Your current video is great. keep it up.

Ramin Riahi on 7/28/2009

Brief and adequate. Loved it!

Carla Wilson on 7/28/2009

Excellent information, but the small window size/size of text was hard to read. Zooming in was great! Is it possible to start zoomed in a little more?

Matthew on 7/28/2009

With all the DMVs in SQL 2005 and above, it's always great to get a tip on how to use one. The sys.database_permissions DMV is extremely useful. Great movie!

K. Brian Kelley on 7/29/2009

Shamshad Ali, You can GRANT SELECT against the schema or even the database itself (GRANT SELECT ON DATABASE::MyDatabase TO MyUser or GRANT SELECT ON SCHEMA::Dbo TO MyUser). You could also go the old route of making the user a member of the db_datareader role. I usually recommend against db_datareader because it gives permissions implicitly, meaning if you query sys.database_permissions, you won't see the access.

Anibal on 7/30/2009

Great example

Travis on 7/30/2009

Very Good Brian, I really like your Security videos in particular, but including the code for downloading would have been nice...

Ahmad Elayyan on 8/1/2009

very good

janet macdonald on 8/12/2009

very good!

Tracy on 8/12/2009

I have SO needed this! I will start using this today - thanks!!

Marian on 9/24/2009

speaker is too speaks too quickly

01EFFB45CF on 1/13/2010

I love the DMV (Data Management View). Worth watching just for that!

Ravi Raj on 6/29/2010

good ome