June 29, 2010 at 4:10 am
Hi,
I have many jobs in my SQL Server 2005, the scenario is mentioned below: -
job1
job2
job3
job4
I want to give only execute & view permission on job1 to user1. And rest of the jobs can be edited by the user1.
Can you explain step by step how can I resolve this issue.
Thanks in advance.
July 4, 2010 at 1:32 am
hi
I 'm in the same situation and finally i had to create a stored procedure that runs my job and i grant execute this Sp to my user . but i want the user can run the job from studio manager and can view the job history too.
is there anybody helpus??
July 5, 2010 at 12:45 am
jobs should be run by either job creator or service account. i dont think we can set permissions as per your requirement at job level.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 5, 2010 at 2:59 am
You can try using Proxy account. You 'll need to create credentials and then proxy account which just have permissions mentioned by you
Here is a link on how to do it:
http://www.sql-server-performance.com/articles/dba/sql_server_job_proxy_account_p1.aspx
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply