I'm sure this is a simple problem, bu I've looked for days...
I have a SQL server that is part of a domain. The domain has many many users.
I want to allow select permissions to anyone within a particular group on the domain.
Right now I have to add a SQL user for every domain user, I'm sure there is a better way?
CREATE USER [Bob] FOR LOGIN [Domain\Bob] GRANT SELECT ON TABLE TO "Domain\Group"
bob is a member of group