Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
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.
db_executor and forgot to add this procedure to it.