Which fixed database role allows members to insert, update and delete data in all user tables?

Options

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

Correct Answer (Detailed Explanation is Below)

B. db_datawriter

Detailed Explanation

  • db_datawriter: Allows members to insert, update and delete data in all user tables.
  • It is used for data modification operations.
  • It does not automatically grant permission to read all data.