YOU HAVE A TEAM MEMBER WHO NEEDS THE ABILITY TO MANAGE SQL SERVER L...
4. You have a team member who needs the ability to manage SQL Server logins
and you do not want them to have permissions to perform any task on the
server. Their responsibilities include resetting logins as well as granting,
denying, and revoking database-level and server-level permissions. Which of
the following server-level roles best fits their permissions requirement?
A. Serveradmin
B. Sysadmin
C. Securityadmin
D. Processadmin