My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.