Who’s In Your Fixed Server Roles?

It's 10PM*. Do you know who your sysadmin role members are? SQL Server's fixed server roles control incredibly broad permissions across your entire instance. For this reason, membership in these roles should be granted carefully and reviewed often. Fortunately, reviewing role membership is extremely easy, so you can always answer the above question better than Homer. The Easy Way: SSMS GUI In the SSMS Object Explorer, open the "Security" folder for an instance, and then open "Server Roles". You'll see it displays the 9 fixed server roles. Double-clicking on any role brings up a dialog that shows all its members: If you hate typing,…
Read More