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?

score 8 · Accepted Answer · answered Jun 10 '10 at 16:38

8

Using the GRANT command.

USE DBNAME;
GRANT SELECT TO RoleName;
GO

answered Jun 10 '10 at 16:38

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 Jun 10 '10 at 16:41

score 3 · Answer 2 · answered Apr 18 '12 at 13:02

3

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

answered Apr 18 '12 at 13:02

FvR

Through the GUI, view the properties of the Database Role 'db_datareader'. On the General tab, under 'Members of this role:', click 'Add...'. This dialog allows selection of either users or other database roles. – Real World IS Mar 04 '15 at 20:04

2 Answers2