Hi,
I need to give access to a domain user group DOMAIN\Developers so that they
can ONLY start/stop SQL Jobs. Which is the best role to grant.
Thanks
Reddipermissions to run sp_stop_job and sp_start_job(msdb) plus permissions to
execute xp_sqlagent_enum_jobs(master) if accounts are not in sysadmins
and/or do not own the sqlagent jobs
"Reddi" <Reddi@.discussions.microsoft.com> wrote in message
news:2F34F361-C7B3-426B-AAC2-976E93039EC6@.microsoft.com...
> Hi,
> I need to give access to a domain user group DOMAIN\Developers so that
they
> can ONLY start/stop SQL Jobs. Which is the best role to grant.
> Thanks
> Reddi
Showing posts with label theycan. Show all posts
Showing posts with label theycan. Show all posts
Friday, March 23, 2012
Permissions question
Labels:
access,
database,
developers,
domain,
group,
jobs,
microsoft,
mysql,
oracle,
permissions,
role,
server,
sql,
theycan,
user
Subscribe to:
Posts (Atom)