April 26, 2004 at 2:24 pm
Hi All,
I am a production DBA and have a produciton & test environment configured. There are several programmers who have Sys Admin access to the Test environment, this is where they do their work. Production is pretty much locked down.
One of the programmers wishes to be able to view the production jobs as well as the package logs of the DTS Packages via Enterprise Manager.
Is there a way to do this without giving him Sys Admin access?
Thanks in advance,
Chris.
Chris.
April 26, 2004 at 4:41 pm
I had the same problem, and one of the users at this site pointed to a targetserverrole for viewing the jobs. All members of that role would be able to view the jobs. Regarding the DTS packages it comes down to granting permissions to sp_enum_dtspackages and sp_get_dtspackage stored procedures in msdb. The guest user may already have permissions by default. If that was removed as part of the lockdown (recommended), you may need to grant the user these two procedure exec perms explicitly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply