Perhaps this is a subject that has been discussed before, but I can't narrow it down.
Can someone give me a rough idea or example of what I'm looking for?
Here's the scenario -
I have ~1000 sales territories. I want my territory managers to be able to log in, and only view their own territory for some data, and nation wide for other data.
I want to use windows authentication. Who wants to manage 1,000 usernames and passwords?
SQL server 2008
Thanks,
Evan