Hi Orlando,

We have now retried the changes in production enviroment - doing one step at a time and testing the application afterwards.

As soon as we changed ownership of schema A...

In fact, we are already considering getting help from Microsoft Support.

But as I mentioned, we are not able to reproduce the case in our dev/test environments.

Our only other option will...

Actually, the view contains data from 2 tables. But they are both in schema A - so it shouldn't make any difference.

Here are the results of the query:

Prod:

table1_ownertable2_ownerview_owner

sys ...

You are asking about the owner of A.SomeTable and you sent a SQL for retrieval of that information.

The result of that SQL is 0 rows.

And the reason is that...

I would believe that remote join operations will only be possible if the remote db is also a SQL server db. In this case where the remote db is Oracle,...

Thank you for a very detailed walk through of all the steps.

The set-up is exactly as you describe it.

And I totally agree, that the ownership chain breaks when going...

In fact, we tried to reproduce the problem at our test environment by restoring a backup of both databases involved. We used a fresh backup of DBX (the unchanged db)...

Thank you for your suggestions.

Yes - The synonym in db DBX is in a schema owned/authorized by dbo.

And I do understand why you are suggesting that even DBX should be...