Oracle connector - bulk load fails if not the table owner
Posted: Mon Oct 18, 2010 9:15 pm
Using the Oracle Connector Stage, I connect to a database using a DB user who is not the table owner (for security reasons, no application at my company establishes a connection as the schema that owns the tables).
A regular insert works. i.e. I have all the synonyms and grants set up correctly.
However, if I try to do a bulk load, I get a "table or view not found" error.
Bulk load when connected as the table owner works.
Has anyone encountered this? I assume there is no workaround except to connect as the table owner. My guess is that the stage reads some dictionary table.
What is the underlying technology of the bulk load? Is it using SQL Loader, or is it just an INSERT APPEND with NO LOGGING?
THANK YOU
A regular insert works. i.e. I have all the synonyms and grants set up correctly.
However, if I try to do a bulk load, I get a "table or view not found" error.
Bulk load when connected as the table owner works.
Has anyone encountered this? I assume there is no workaround except to connect as the table owner. My guess is that the stage reads some dictionary table.
What is the underlying technology of the bulk load? Is it using SQL Loader, or is it just an INSERT APPEND with NO LOGGING?
THANK YOU