Deploy to another schema

System

I am trying to update to a database table in another schema that I have permission to, however when I do try to update the table OD creates a new table in my schema and not update the other one.

In short userA is trying to update to userB.tablename. UserA has all the permissions/grants to userB's schema.

I have tried to do userB.table in the connect string too.

Ambuj

I am trying to update to a database table in another schema that I have permission to, however when I do try to update the table OD creates a new table in my schema and not update the other one. In short userA is trying to update to userB.tablename. UserA has all the permissions/grants to userB's schema. I have tried to do userB.table in the connect string too.

Many users face the same problem when they start deploying any data to any new schema. I would suggest you to test deployment with some fixed data first and then deploy it from DCR... Also check the constraints of the table.... if there is any constraint on the table, then first drop them n then test the deployment...