Re: SQL Jobs & Security
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: Thu, 6 May 2004 21:41:13 +0100
If you are on Service Pack 3 or higher you can add them to the
TargetServerRole in msdb. Prior to SP3, this role had more permissions than
it does now. After SP3 the role can view job properties + history of all
jobs but not modify or run jobs they don't own
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Ken Widner" <email@example.com> wrote in message news:firstname.lastname@example.org... > Is there a way to give someone the ability to see SQL Jobs > if their not the Owner and not in the SA account.? I > heard it could be done with changing a table or SP in the > MSDB database. Anyone heard of this or has done this.?