question

ffarouqi avatar image
ffarouqi asked

Granting user accounts rights to run only specific SQL agent jobs that run SSIS packages

We have a couple of users that we only would like to run SQL agent jobs that would execute SSIS packages and don't want them to have access to any other thing except to run the jobs. Is there a way I can accomplish this requirement.

ssissql-agentsql-server-2016sql-security
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.