The execute permission was denied

Question

Hi we are running ssis packages from Integration server, we got this error. Please review the error message and tell me how to troubleshoot this issue.

Thanks

---

DBA

Answer 1

Your user does not have permission to execute on the object... You'll need to grant it permission.

---

Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.

Answer 2

Hi DBA,

Just as the error message said ”The EXECUTE permission was denied on the object ‘HyperonExtract_Current’, database ‘xxxx’, schema ‘hyp’.”, the current use does not have permission to execute on the object ‘HyperonExtract_Current’, database ‘xxxx’, schema ‘hyp’.

To fix this issue, please grant the execute permission to the user with the query below:

USE xxxx;
GRANT EXEC ON hyp.HyperonExtract_Current TO user

References:
GRANT System Object Permissions (Transact-SQL)
The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 3

Thanks for your reply..The issue happen due to the target overwritten by the user.

---

DBA