Printed 2013/12/08 11:20AM  How do the fixed Database and Server
roles map to more specific permissions?  By Kenneth Fisher,
2013/09/09  I recently asked what the difference is between
granting SELECT to a user (at a database level) and adding the
user to the db_datareader role on StackExchange. The answer I
got from RLF sent me to a link with some awesome charts showing
how the various roles map to individual permissions. I realize
that it’s a high level overview of the permissions and doesn’t
display (for example) object level permissions, ie syssessions
is only accessible by sysadmin. However it’s still an excellent
reference tool. Personally I plan on printing out to put on my
wall next to my DMV poster.  Filed under: Documentation,
Microsoft SQL Server, Security, Settings, SQLServerPedia
Syndication Tagged: database permissions, Documentation,
microsoft sql server, security, server permissions