New SQL Monitor Metric: Principals with Sysadmin Login

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 11 Nov 2013 07:00:00 UT Indexed on 2013/11/11 10:13 UTC
Read the original article Hit count: 176

Filed under:

This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.

© SQL Server Central or respective owner