March 30, 2009 at 10:41 am
I have a new developer that has inherited quite a few DTS packages that do everything from executing .exe files to calling stored procedures, ftping files , etc..
On our Production SQL Server, he has read-only to the User Databases only. Problem is, he cannot see the JOBS under the SQL Server Agent. I would like to give him access to this - what kind of Server Wide permissions would he need for this?
March 30, 2009 at 3:33 pm
Does he only need to see the jobs or does he need more extensive permissions?
Greg
March 31, 2009 at 5:51 am
Just to see the jobs and the job history would suffice. Can this be done? I can't figure out how to do it...
March 31, 2009 at 9:42 am
Try granting EXECUTE permission on these stored procedures in msdb: sp_help_job, sp_help_jobstep, sp_help_jobschedule, and sp_help_jobhistory.
I would probably create a role in msdb and grant EXECUTE on the stored procedures then add the user to the role. Then you could add other users to the role if you need to later.
Greg
April 3, 2009 at 7:15 am
Thanks!!! What I ended up doing was making him a memeber of the TargetServers role in the MSDB database. He can now view jobs and job history.
What he also wants to do is view DTS Packages in Production. How so I grant him this access without granting sysadmin - this is a production box!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply