Permission/role needed to both modify and execute jobs

What SQL Server permission(s) are required to both modify and execute jobs i
n
SQL Server 2000 and SQL Server 2005?
Thank you.
--
MikeMike
You posted this in microsoft.public.sqlserver.security on 6 Jan, and
microsoft.public.sqlserver.dts 8 Jan Uri and Allan have replied to this.
Please do not muti-post http://www.aspfaq.com/etiquette.asp?id=5003
John
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1767DE69-A68F-44AD-A821-924352B87079@.microsoft.com...
> What SQL Server permission(s) are required to both modify and execute jobs
> in
> SQL Server 2000 and SQL Server 2005?
> Thank you.
> --
> Mike|||I don 't see an answer for SQL Server 2005 (please see below). Any help
would be appreciated. Thank you.
SQL Server 2005
1) I haven't played to much with this issue. If I remember well you can
create a proxy account to run jobs
with an acount that is not a member of sysadmin server role.
--
Mike
"John Bell" wrote:

> Mike
> You posted this in microsoft.public.sqlserver.security on 6 Jan, and
> microsoft.public.sqlserver.dts 8 Jan Uri and Allan have replied to this.
> Please do not muti-post http://www.aspfaq.com/etiquette.asp?id=5003
> John
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1767DE69-A68F-44AD-A821-924352B87079@.microsoft.com...
>
>|||Additionally, if you would have read my new questions, you would have notice
d
that they had changed from just run, to both modify and run/execute.
Thank you.
--
Mike
"John Bell" wrote:

> Mike
> You posted this in microsoft.public.sqlserver.security on 6 Jan, and
> microsoft.public.sqlserver.dts 8 Jan Uri and Allan have replied to this.
> Please do not muti-post http://www.aspfaq.com/etiquette.asp?id=5003
> John
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1767DE69-A68F-44AD-A821-924352B87079@.microsoft.com...
>
>|||BOL for 2005 has lots of very good information on this subject. Much more
than you can expect someone to post here. There is no reason to reinvent the
wheel so have a look at this section of BOL for a start.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d728a2f5-6a2d-40f7-aba7-ed51
b930072d.htm
Andrew J. Kelly SQL MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:63F20246-5FAC-421F-9A2E-80C68064226F@.microsoft.com...[vbcol=seagreen]
>I don 't see an answer for SQL Server 2005 (please see below). Any help
> would be appreciated. Thank you.
> SQL Server 2005
> 1) I haven't played to much with this issue. If I remember well you can
> create a proxy account to run jobs
> with an acount that is not a member of sysadmin server role.
> --
> Mike
>
> "John Bell" wrote:
>|||Are you a Microsoft employee? If not, I still don't have answers for the
question below. Microsoft, if you could please help, I would highly
appreciate it.
Are different permissions required to both modify and run SQL Server 2000
jobs and DTS packages?
Thank you.
--
Mike
"Andrew J. Kelly" wrote:

> BOL for 2005 has lots of very good information on this subject. Much more
> than you can expect someone to post here. There is no reason to reinvent t
he
> wheel so have a look at this section of BOL for a start.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d728a2f5-6a2d-40f7-aba7-ed
51b930072d.htm
>
> --
> Andrew J. Kelly SQL MVP
>
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:63F20246-5FAC-421F-9A2E-80C68064226F@.microsoft.com...
>
>|||What does my employment status have to do with if you have an answer or not?
You specifically stated that you needed an answer for SQL2005. This is from
your last post:
[vbcol=seagreen]
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:63F20246-5FAC-421F-9A2E-80C68064226F@.microsoft.com...
And here is the answer that Allan Mitchell gave you in the DTS group that
you cross posted to.
[vbcol=seagreen]
Hello mike,
In 2K, So long as you can access the package you can change it.
In 2K5 a way of implementing security can be found here in BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/9702e90c-fada-4978-a473-1
b1423017d80.htm
<<
You replied:
[vbcol=seagreen]
Thank you, and have a great weekend.
--
Mike
<<
So I am confused as to what you really want. Do you just not trust the
answers since we are not MS employees or is there something else?
Andrew J. Kelly SQL MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:E42F971F-E556-4D5B-9203-2AF587D4A7A6@.microsoft.com...[vbcol=seagreen]
> Are you a Microsoft employee? If not, I still don't have answers for the
> question below. Microsoft, if you could please help, I would highly
> appreciate it.
> Are different permissions required to both modify and run SQL Server 2000
> jobs and DTS packages?
> Thank you.
> --
> Mike
>
> "Andrew J. Kelly" wrote:
>|||The BOL link that Andy posted has 100% of the information you are looking
for in it. Microsoft spends millions on writing BOL, so that answers to at
least 80% or more of the questions that could get asked are already
answered, as long as people actually read it.
Someone's employment status has absolutely nothing whatsoever to do with
posting an answer. No, Andy isn't a Microsoft employee and that is
completely irrelevant. He is a SQL Server MVP and has been for a long time.
The MVP program was created to provide online support for customers of
products. With a few exceptions, the people in the MVP program are the best
information resources that exist in the industry.
If you want anyone to actually answer your questions, then I'd suggest that
you don't insult people who take their time to answer questions.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:E42F971F-E556-4D5B-9203-2AF587D4A7A6@.microsoft.com...[vbcol=seagreen]
> Are you a Microsoft employee? If not, I still don't have answers for the
> question below. Microsoft, if you could please help, I would highly
> appreciate it.
> Are different permissions required to both modify and run SQL Server 2000
> jobs and DTS packages?
> Thank you.
> --
> Mike
>
> "Andrew J. Kelly" wrote:
>