How can I grant datareader to a sql role?

Question

Is it possible to grant the datareader privileges to a SQL Server Database Role rather than a User?

Answer 1

Using the GRANT command.

USE DBNAME;
GRANT SELECT TO RoleName;
GO

Answer 2

You could add your (user defined) database role to db_datareader as a role member, using the UI.