We are new to ODI and as such experimenting with connections to all our data sources. We are using MS SQL Server 2014 for our target database server. Repositories are build on this server also. During our testing, we had an issue with SQL Bulk Dataloader. In trying to correct that error, our DBA was making many changes to users and permissions in our sql server instance. As a result, all interfaces are now failing on steps to create work tables (very basic stuff, i know). Error message = CREATE TABLE permission denied in database.... The interfaces had been working prior to our DBA making adjustments, so we know we had the correct configuration for a while. My question... what user/permission could have been deleted? What user is in control when the agent runs an interface?