How do the fixed Database and Server roles map to more specific permissions?Leave a comment
September 9, 2013 by Kenneth Fisher
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.
Category: Documentation, Microsoft SQL Server, Security, Settings, SQLServerPedia Syndication | Tags: database permissions, Documentation, microsoft sql server, security, server permissions