SSIS The EXECUTE permission was denied on the object - VisualCron - Forum

Community forum

Fantazma
2020-09-14T09:23:40Z
Helo,

I have issue when I try to Execute a SSIS Package, I must give credentials to the Builtin\Users group on our SQL box to get any logs on the SQL box.
When I give the user I want to authenticate (logonscripts) has the appropriate SQL permissions to execute, but I take them away from Builtin\Users, I get the following error:

“The EXECUTE permission was denied on the object 'sp_ssis_getpackage', database 'msdb', schema 'dbo'.). “

I have try to give the rights:

use [master]
GO
GRANT EXECUTE ON [dbo].[sp_ssis_getpackage] TO [logonscripts]

Source : https://www.get-itsoluti...ied-on-the-object/  

What is the wrong here?

Thnx
thomas
2020-09-14T12:55:56Z
Scroll to Top