Not Able to Access a Synonym from SQL Server Linked Server on Oracle RDBMS.
Last updated on SEPTEMBER 20, 2010
Applies to:Oracle Provider for OLE DB - Version: 10.2.0.1 to 126.96.36.199 - 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms