Environ is Server 2008 windows domain. SQL 2008 servers.
Some of my users need to edit the content of jobs that they do not own. So, they need to edit jobs owned by someone else. I would like to grant them permissions to do so, but I'm not sure of the best way to do this.
We use Windows authentication so I'd like to use a domain account or group. The odd thing is, we want to move people in and out of this group as needed and not leave them in there all the time.
Should I build an AD group, drop it into local workstation admins group and then delegate a couple of admins rights to add/remove people from that group?
Thoughts on best way to accomplish this?