Re: SQL Jobs & Security
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/06/04
- Next message: Jasper Smith: "Re: SQL Backup File Not Secure?"
- Previous message: Kevin McDonnell [MSFT]: "RE: Allowing user to connect to his database"
- In reply to: Ken Widner: "SQL Jobs & Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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" <kewidner@gapac.com> wrote in message news:948501c433a0$5da058b0$a401280a@phx.gbl... > 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.?
- Next message: Jasper Smith: "Re: SQL Backup File Not Secure?"
- Previous message: Kevin McDonnell [MSFT]: "RE: Allowing user to connect to his database"
- In reply to: Ken Widner: "SQL Jobs & Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
