views:

131

answers:

1

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

+3  A: 

Using the GRANT command.

USE DBNAME;
GRANT SELECT TO RoleName;
GO
Serapth
Also, it might not let you grant to the built-in roles ("db_*") - at least, it won't through the UI. But you can grant to roles that you create.
GalacticCowboy