Sunday, February 19, 2012

Giving access to manage sql jobs

Hello,
I have a someone that I would like to be able to create/modify sql jobs.
What permissions, and how, can I give them permissions without making them
an sa? Is there is a good reference out there that describes how to set
permissions like this? Thanks in advance.
JakeJake
Do you want the user to be able to modify only his/her jobs or all people?
He/She mus be a member of sysadmin server role otherwise you are going to
create a proxy account for the user. Please refer for more details to the
BOL
"Jake Smythe" <rondican@.hotmail.com> wrote in message
news:ennyTBZMFHA.164@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have a someone that I would like to be able to create/modify sql
jobs.
> What permissions, and how, can I give them permissions without making them
> an sa? Is there is a good reference out there that describes how to set
> permissions like this? Thanks in advance.
> Jake
>

No comments:

Post a Comment