Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.