Which fixed database role can manage database permissions and role membership?

Options

  • A. db_datareader
  • B. db_securityadmin
  • C. db_backupoperator
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. db_securityadmin

Detailed Explanation

  • db_securityadmin: Can manage permissions and role membership in a database.
  • Members can grant, deny and revoke permissions, subject to security restrictions.
  • It is a fixed database role in SQL Server.