Which SQL Server fixed server role can manage server-wide security logins and their properties?

Options

  • A. securityadmin
  • B. processadmin
  • C. diskadmin
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. securityadmin

Detailed Explanation

  • securityadmin: Manages logins and their properties at the server level.
  • It can grant, deny and revoke server-level permissions.
  • Its privileges should be assigned carefully because they can have significant security implications.