Not Able to Access a Synonym from SQL Server Linked Server on Oracle RDBMS.
(Doc ID 1147909.1)
Last updated on APRIL 09, 2020
Applies to:Oracle Provider for OLE DB - Version 10.2.0.1 to 18.104.22.168 [Release 10.2 to 11.2]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
When trying to access a data from a synonym SQL Server returns
Msg 7357, Level 16, State 2, Line 1
Cannot process the object ""TEST"."EMP"". The OLE DB provider "OraOLEDB.Oracle" for linked server "TIGER" indicates that either the object has no columns or the current user does not have permissions on that object.
New query or changing the syntax on SQL Server query from an openquery to a four-part name query.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document