mcinmx01
Right there with Babe
Points: 750
More actions
November 14, 2002 at 12:25 pm
#64616
We want our contractors to have read capability on SQL Server Jobs, but not be able to modify them.
Is there any security context that will allow this?
Is there a way to run sp_help_job such that it will allow to read non-owner Jobs?
Steve Jones - SSC Editor
SSC Guru
Points: 728159
November 14, 2002 at 1:23 pm
#441378
I'd batch a script of the jobs and store it somewhere. Easier than messing with permissions on the jobs.
Steve Jones
sjones@sqlservercentral.com
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Antares686
Points: 125444
November 14, 2002 at 3:40 pm
#441406
I agree as it buffers current security against unforseen issues.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply