SQL Server users and groups 1

[wbodger]

I am wondering how I would go about creating a group to which I could add 3 or 4 user accounts and give that group the db_datareader role in specific databases on my server.

 

[SQLBill]

Create a Windows active directory group. Add the users to that group and then add the group to SQL Server.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[wbodger]

Cool, thank you.

 

[yelworcm]

Also, roles can be nested in roles in a database, so you could create a role in the database, add all four users to it, and add the role to the db_datareader role. It is just a matter of at what level you want to administer the membership of that role.

 

[wbodger]

So, I could create a custom role, then add the windows users to that role and then add db_datareader to the created role?

 

[yelworcm]

You would add the newly created role to db_datareader

create role newreaders

exec sp_addrolemember db_datareader, newreaders

 

[wbodger]

Got it, thanks!