Which fixed database role provides full control over a database?

Options

  • A. db_owner
  • B. db_datareader
  • C. db_accessadmin
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. db_owner

Detailed Explanation

  • db_owner: Members can perform all configuration and maintenance activities in the database.
  • They have broad administrative permissions within that database.
  • It is different from the server-level sysadmin role.