Hi How can I set permissions againt existing windows groups in sql server 2005
migrated from stackoverflow.com May 27 '10 at 23:43
This question came from our site for professional and enthusiast programmers.
Expand the Security in Management studio, Right click on Logins and select new, Hit the Search button next to Login Name,
hit the Advanced button Click on Find now Your Groups/logins will appear in the search results. Select Groups/Logins
close all open dialogs by clicking ok Now you have a login
Associate the login / group to Databas object(s) by right clicking on the Database (name) and permissions- You can also associate permission to child objects of the database (Tables/Sps etc) individualy