GRANT SQL PERMISSIONS TO AN ACTIVE DIRECTORY GROUP
Posted on 2010-11-16
I need to create SQL tables in a query and then grant permissions. This is a process that will be repeated over and over as one of my VB.net programs is executed.
I have already succeeded in creating the tables and granting permissions to a SQL group called DYNGRP (a default group with Dynamics GP). However, I also have a windows active directory group called SNUGZ\shopfloor. When I try to grant permissions to this group, the query fails because of the '\'. If I try to just use shopfloor, the group is not recognized.
Can someone tell me how to either add this windows group to the SQL group DYNGRP, or what syntax can I use in my query to give permissions directly to SNUGZ\shopfloor?