Here’s a pretty sweet blog on permissions by the SQL Server Security team which goes over some good stuff in the areas of Authentication Modes, Typical Scenarios, Assigning Permissions, and the Permission Hierarchy. They call it ‘basics’, but it looks like good to me, regardless of level, so check it out. One really cool thing in this post is the killer permissions poster link, one which I have not seen before that (duh, looking at it closer, it has an Aug 25 date…yesterday), I need to study more for sure…gives an awesome view at server and database permissions.
Great job here for sure! Kudos!!!
Lee
--------------------------
You thought I wouldn’t like the post, based on my last blog did you?
Blog
http://blogs.msdn.com/b/sqlsecurity/archive/2011/08/25/database-engine-permission-basics.aspx
Killer permissions poster
http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/5710.Permissions_5F00_Poster_5F00_2008_5F00_R2_5F00_Wiki.pdf
ff1f2d37-d9a0-4736-bc5a-6f8cc226351b|0|.0