Is it possible to grant the datareader privileges to a SQL Server Database Role rather than a User?
Using the GRANT command.
USE DBNAME; GRANT SELECT TO RoleName; GO