The #MS_DatabaseConnector## Role: #SQLNewBlogger
I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle of least privilege is followed.
In this post, I look at one of these, the ##MSDatabaseConnector## role.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Users and Logins
This role is a new one that contains very narrow permissions. It allows a login to connect to any database without requiring a user account mapping. Typically if I create a login for “Steve”, I…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.