Configure security on the target table's database

Any account under which the specified query might be executed needs to be granted permission to execute that query.

1. Open Microsoft SQL Server Management Studio and connect to the SQL Server Instance that contains the target table.

2. Under the SQL Server Instance, expand the Security folder, and then expand the Logins folder.

3. Right-click the Logins folder and choose New Login.

4. Use the Search button to find the group created in the previous section and choose that group for the Login name.

5. Select the Windows authentication option, and select the database that contains the target table as the Default database.

6. Select the User Mapping page.

7. Select the row for the Database that contains the target table.

8. Select the Map check box for the selected database.

9. Expand the Databases folder, then the folder for the target database, and grant the necessary permission to execute the query that will be used to the Login just created.

   For example, if the query that will be used is a SELECT statement that specifies a single table, expand the Tables folder for the target database, expand the Tables folder, then right-click the table to which the query refers and choose Properties.

10. In the Table Properties window, select the Permissions page, search for and select Login, then Grant the Login the Select Permission and click OK to close the Table Properties window.

11. Close Microsoft SQL Server Management Studio.