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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 847 other followers

%d bloggers like this: