locked
The execute permission was denied RRS feed

  • 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

    Thursday, March 19, 2015 4:33 PM

Answers

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

    DBA

    Friday, March 20, 2015 1:59 PM

All replies

  • 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.

    • Proposed as answer by BI_Support Friday, March 20, 2015 11:52 AM
    Thursday, March 19, 2015 4:37 PM
  • 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

    • Proposed as answer by BI_Support Friday, March 20, 2015 11:52 AM
    Friday, March 20, 2015 9:29 AM
  • Thanks for your reply..The issue happen due to the target overwritten by the user.

    DBA

    Friday, March 20, 2015 1:59 PM