I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question about server logins and database users in the following scenario:
We have 30 database users that require the same permissions, each with their own AD accounts.
When setting up SQL server access for these SQL writers what is the most performant approach for giving a group of users with the same permissions access to a server/database?
I appreciate that this could be achieved via several approaches but am keen to learn the performant approach to managing relationships between server logins/database users/database roles.