ODP.Net - OracleBulkCopy - ORA-01031: insufficient privileges when inserting into object of schema o
If am I logged in as the owner "CVA" I am able to perform the BCP without any issue. If I login as another user with INSERT rights to the table it fails with the error below. I am fairly sure the permissions are configured correctly as I am able to BCP the data using the SqlLdr utility successully when logged in as a user other than CVA.
Example Code:
using (OracleBulkCopy bcOra = new OracleBulkCopy(cnnOra))
{
bcOra.BulkCopyTimeout = 30;
bcOra.DestinationTableName = "CVA.RT_SKILL_TEMP";
bcOra.WriteToServer(drOdbc);
}
Full Exception:
Oracle.DataAccess.Client.OracleException ORA-01031: insufficient privileges at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)