sandeep
sandeep

Reputation: 1

sql server 2008

I have a job say somthing like X. If i want to give permissions to execute the X job to a user . what role I have to assign to the user. But the user should not be able to edit or delete or modify the job and this job is in share environment. no other should not prevlge to run the job X.

Upvotes: 0

Views: 61

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300549

Take a look at SQL Server Agent Proxies: Creating SQL Server Agent Proxies

Upvotes: 1

Related Questions