Assign a Database Role to Multiple Logins using SSMS

Here are the steps to assign a database role (eg: db_owner) to Multiple Logins:

1. Open SQL Server Management Studio (2005/2008). In the Object Explorer, after connecting to SQL Server, expand the Databases folder > Expand your Database Node (For demonstration purposes, I have chosen ‘Adventure Works’ database)

2. Now navigate to the Security > Roles > Database Roles folder. Double click on db_owner

3. In the Database Role Properties dialog box, click on the ‘Add’ button to open up the ‘Select Database User or Role’ dialog box and the enter the name of the user/role to add. You can even click on the Browse button to search the names.

Click OK and then OK again once you are done adding the users/roles to the Database login.

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook