Sqlagentuserrole



I have a multi-part question regarding giving permissions to manage sql agent
jobs.
First, I created a SQL user id (SQL Server 2005) which I gave read/write
permissions to the necessary databases against which jobs will run, and I
also gave the user SqlAgentUserRole. But I'm experiencing multiple problems.

1-The user can only see jobs he owns. I'd like to grant permission to
manage all jobs regardless of the owner.

2 - Even on jobs the user owns, he cannot use an output file because when he
tries to save, SQL throws a permission error stating that you must be a
sysadmin to write to the output file.

And worst of all, I change ownership of a pre-existing job to the new user,
but when he opened the job that had an output file already defined, SQL threw
the premission error and then deleted all steps in the job that had the
output file previously defined. I can see how SQL would prevent the user from
saving, but I can't imagine why SQL would delete previously defined steps
too. Has anyone had this happen? I'm guessing it's a bug.

Is there a way to provide my user with the access needed to manage all jobs
including output files without granting system admin access in general?
.



Relevant Pages