Tom Van Harpen (6/25/2013)
We dont have a good solution but we do have a work around.Basically right now we have a user that sets up jobs as themselves and once the job is setup correctly they change the owner to our standard ssis job owner acct. But, once that is done they are no longer able to make changes. So this person then uses the credentials of the ssis job owner acct to login and make changes.
....
This is interesting. Perhaps create a stored procedure which will make this user the owner of this specific job. Grant execute to the new procedure for this user. Now the user can manage the job as needed without having access to the SSIS credentials. Additionally, you could schedule a job that will override the new stored procedure and revert the ownership to the SSIS account.