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
>
>
>

Grant job view and execute

Hello,
How can i grant a user to view and execute Jobs on SqlSrv2K without grant
SystemAdministratr previleges.
Thanks
Leandro Loureiro dos SantosLeonardo
BOL says
How to give others ownership of a job (Enterprise Manager)
To give others ownership of a job
1.. In the details pane, right-click the job, and then click Properties.
2.. In the Owner list, select a login.
Assigning a job to another login does not guarantee that the new owner has
sufficient permission to run the job successfully.
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:uD5wcNH4DHA.2380@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How can i grant a user to view and execute Jobs on SqlSrv2K without grant
> SystemAdministratr previleges.
> Thanks
> Leandro Loureiro dos Santos
>|||Actually, i need non-system administrators users could view and execute a
job.
How can i do that?
"Leandro Loureiro dos Santos" <leandro@.email.com> escreveu na mensagem
news:uD5wcNH4DHA.2380@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How can i grant a user to view and execute Jobs on SqlSrv2K without grant
> SystemAdministratr previleges.
> Thanks
> Leandro Loureiro dos Santos
>

Grant job view and execute

Hello,
How can i grant a user to view and execute Jobs on SqlSrv2K without grant
SystemAdministratr previleges.
Thanks
Leandro Loureiro dos SantosLeonardo
BOL says
How to give others ownership of a job (Enterprise Manager)
To give others ownership of a job
1.. In the details pane, right-click the job, and then click Properties.
2.. In the Owner list, select a login.
Assigning a job to another login does not guarantee that the new owner has
sufficient permission to run the job successfully.
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:uD5wcNH4DHA.2380@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hello,
> How can i grant a user to view and execute Jobs on SqlSrv2K without grant
> SystemAdministratr previleges.
> Thanks
> Leandro Loureiro dos Santos
>

---

|||Actually, i need non-system administrators users could view and execute a
job.
How can i do that?
"Leandro Loureiro dos Santos" <leandro@.email.com> escreveu na mensagem
news:uD5wcNH4DHA.2380@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hello,
> How can i grant a user to view and execute Jobs on SqlSrv2K without grant
> SystemAdministratr previleges.
> Thanks
> Leandro Loureiro dos Santos
>

---

sql

GK - Granting on all objects but not on JOBs ???

Hi,
I just wonder why I can grant / revoke on all objects ( tables, stored proce
dures etc ) and NOT on JOBs?
Thanx in advance,
GKramerHi,
You have to be member of SYSADMIN server role or member of DB_OWNER role
in MSDB database.
Thanks
Hari
MCDBA
"GKramer" <anonymous@.discussions.microsoft.com> wrote in message
news:92043A96-9386-486B-BC43-644C6EBB9CE6@.microsoft.com...
> Hi,
> I just wonder why I can grant / revoke on all objects ( tables, stored
procedures etc ) and NOT on JOBs?
> Thanx in advance,
> GKramer|||Jobs can only be viewed by a sysadmin or the job owner.
Rand
This posting is provided "as is" with no warranties and confers no rights.

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
>