Granting Access to Modify jobs

How do you grant a user access to modify SQL Server jobs without granting
them full access to the Server. I want them to have access to certain
databases and also have the ability to modiy/create jobs.On Feb 14, 1:47 pm, Don <D...@.discussions.microsoft.com> wrote:
> How do you grant a user access to modify SQL Server jobs without granting
> them full access to the Server. I want them to have access to certain
> databases and also have the ability to modiy/create jobs.
They will have to be a Login on the Server, a User in each database
and have some permission in msdb.
See SQL Server 2005 Books Online topics:
Selecting an Account for the SQL Server Agent Service - http://
msdn2.microsoft.com/en-us/library/ms191543.aspx
Implementing SQL Server Agent Security - http://msdn2.microsoft.com/en-
us/library/ms190926.aspx
Security for SQL Server Agent Administration - http://
msdn2.microsoft.com/en-us/library/ms190978.aspx
SQL Server Agent Fixed Database Roles - http://msdn2.microsoft.com/en-
us/library/ms188283.aspx|||We've been unable to get the Agent Roles to work properly for domain account
s
in our environment. A SQL Login that is added to the SQLAgentOperatorRole is
able to create a job (with that login as the owner), edit the job, and
perform all other tasks as documented for this role. HOWEVER, if we add a
domain account to this role, it can create the job but cannot edit it. The
domain account is shown as the owner of the job. The domain account can star
t
the job but can't see the status and can't tell if it's running or not. It
can delete the job and make a new one but the button that should say 'edit'
says 'view'.
"Steve" wrote:

> On Feb 14, 1:47 pm, Don <D...@.discussions.microsoft.com> wrote:
> They will have to be a Login on the Server, a User in each database
> and have some permission in msdb.
> See SQL Server 2005 Books Online topics:
> Selecting an Account for the SQL Server Agent Service - http://
> msdn2.microsoft.com/en-us/library/ms191543.aspx
> Implementing SQL Server Agent Security - http://msdn2.microsoft.com/en-
> us/library/ms190926.aspx
> Security for SQL Server Agent Administration - http://
> msdn2.microsoft.com/en-us/library/ms190978.aspx
> SQL Server Agent Fixed Database Roles - http://msdn2.microsoft.com/en-
> us/library/ms188283.aspx
>
>
>