0

We have a user running an SSIS package from Visual Studio.

The step that is failing is it is trying to run a stored proc but the error within Visual Studio is "The EXECUTE permission was denied on the object 'xxx', database 'yyy'....

But this user has EXECUTE permissions on the database in general, they are accessing SQL Server using integrated security / Windows login.

1
  • Difficult to say why it is happening. Try to look at the connection string the ssis is using for the sql activity.
    – MBuschi
    Commented Sep 26, 2022 at 10:39

1 Answer 1

0

When I granted EXECUTE permission on the stored proc specifically, it works from SSIS.

The user been a member of db_executor database role (without specific object permissions) doesn't seem to be enough for SSIS.

2
  • 2
    There is no built-in database role called db_executor.
    – Zikato
    Commented Sep 26, 2022 at 12:23
  • Sounds like some developer on your end created a new (user defined) role called db_executor and forgot to add this procedure to it.
    – J.D.
    Commented Sep 26, 2022 at 12:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.