Question

Ministry of Health (MOH) has just implemented a new patient information system. All authenticated users of this system with access to the patient database need to be able to only retrieve data from any table within the database. How can you accomplish this functionality with the least amount of effort in SQL Server?
a.Add the users to the db_datawriter fixed database role.
b.Grant the users SELECT permission on every table in the database.
c.Grant the users SELECT permission on the database.
d.Grant the users SELECT permission on every schema in the database.

Answer 1

b.Grant the users SELECT permission on every table in the database.

This option ensures that the users can only retrieve data from the tables within the database without granting them additional permissions such as the ability to modify or delete data. This approach allows for more fine-grained control over the level of access given to the users.