Which SQL Server fixed database role provides read access to all user tables and views?

Options

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

Correct Answer (Detailed Explanation is Below)

A. db_datareader

Detailed Explanation

  • db_datareader: Allows members to read data from all user tables and views.
  • Members can execute SELECT operations on user objects.
  • It does not automatically provide permission to modify records.