Not Able to Access a Synonym from SQL Server Linked Server on Oracle RDBMS.

(Doc ID 1147909.1)

Last updated on SEPTEMBER 20, 2010

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms


Comments
--------
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.

Changes

New query or changing the syntax on SQL Server query from an openquery to a four-part name query.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms