Analytics Software

Hi - I am new at ODI so bear with me.

I am loading from an oracle source to an oracle target. The source system has limited permissions (we have select only). I am just trying to do a simple straight load from the source to a target (differenct data server). When I execute the interface, I'm getting an error stating that I don't have sufficient permissions. It seems that ODI is trying to either create a dblink on the source or is trying to create temp tables on the source. Both of these are not possible given the permissions granted on the source (and they will not grant more permissions).

I get insufficient privs when I select 'execute on' source or when I select 'execute on staging area' in the designer, in the diagram of the interface. I tried to select 'execute on target' but this gave an error in the diagram of "A mapping executed on target cannot reference a source column" which doesn't make any sense to me. Also, in topology, the physical arch of the data server for the source: both schema and work schema are the same source schema.

Help!!

Many Thanks,
Dan