December 22, 2011 at 9:55 pm
i have created 5 jobs in sqlserver. I need to provide only below permission to user. How to achieve this .
1. Execute job
2. View job history
Thanks for your help.
December 23, 2011 at 12:04 am
Grant permissions to run an SQL server job.
Unfortunately, I don't think this approach will do when it comes to view job history, for that I think you have to stick with SQL Server Agent Fixed Database Roles.
December 23, 2011 at 12:32 am
Another thought. Just provide the permissions to execute the job to a user and introduce audit/logging steps (may be a log file) in the JOB. This way jobs can be traced outside the scope of SQL Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply