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: 736478
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://www.sqlservercentral.com/columnists/sjones
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