You have a reference database named OrderHistory, which should not allow any data to be modified.
How can you ensure, with the least amount of effort, that users can only read data from the database?
A.
Add all database users to the db_datareader role.
B.
Create views for all the tables and grant select permission only on the views to database users.
C.
Set the database to READ_ONLY.
D.
Grant select permission on the database to all users and revoke insert, update, and delete permissions from all users on the database.