This may be a bit too elementary question for this site but is it possible to control SQL Server authenticated logins using groups? So is it possible to assign sql logins under groups and give rigths for these groups? If so, are these groups only seen for an instance in question?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
When working with SQL Logins you "group" them by using roles within SQL Server. Roles are created at the database-level but with SQL Server 2012 you will be able to create them at the server-level as well.
Once the role is created you can assign specific permissions to that group and it will be applied to the logins that are member of that role. The roles are localized to the instance you are under and are not visible or accessible to remote instances. You will only be able to add the logins in that instance of SQL Server to the roles.
If I understand your question, logins using SQL Server authentication, no; logins using Windows Authentication, yes. The Windows logins are placed into a Windows group (or groups) eliminating the need to each user's Windows login set up under SQL Server.