Hello Experts Exchange
I have a SQL Agent job that runs under a user, when the user has sysadmin rights, but when I remove sysadmin right the job does not run, and has the following error.
Executed as user: TELFORD\SqlAgent. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 16:56:21 Error: 2015-10-15 16:56:24.02 Code: 0xC0202009 Source: Data Flow Task OLE DB Source  Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E09 Description: "The SELECT permission was denied on the object 'Master_Selection_Criteria', database 'BPC_LOOKUPS', schema 'dbo'.". End Error Error: 2015-10-15 16:56:24.02 Code: 0xC004706B Source: Data Flow Task SSIS.Pipeline Description: "OLE DB Source" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2015-10-15 16:56:24.02 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2015-10-15 16:56:24.02 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 16:56:21 Finished: 16:56:24 Elapsed: 2.157 seconds. The package execution failed. The step failed.
The job runs a SSIS package.
I want to remove sysadmin rights from the user account, what rights do I have to give this user to get the job to work?