Re: Problems using synonyms in Oracle with ODBC

From: Noah Monsey <noah_at_indirect.com>
Date: 1995/05/21
Message-ID: <D8y3p6.6Ms_at_indirect.com>#1/1

jensr_at_hrp.no (Jens Roynlid) wrote:

>We have a problem connecting a Visual Basic application to an Oracle database
>using ODBC:
 

>We are unable to connect to tables names which are represented by
>public synonyms in the Oracle DB. For example, the following statement will
>fail:
 

>select * from hem_users;
 

>where hem_users is a public synonym in the Oracle DB. The error message is
>"coudn't find table or object handelmasys.hem_users" where handelmasys is the
>owner of the table which the hem_users public synonym refers to.
 

>Any suggestions/ideas?

Idea: Does the user which is trying to access your table have select, insert, update, or all permissions in the Oracle database?

Creating a public synonym is a good idea, but the user still needs permission to see the table. ========= ========= ========= ========= =========

Noah Monsey                       noah_at_indirect.com

========= ========= ========= ========= ========= The only dumb question is the one that you don't ask. ========= ========= ========= ========= ========= Oracle Master Database Administration April 1992 Oracle Master Application Development April 1992 ========= ========= ========= ========= ========= Received on Sun May 21 1995 - 00:00:00 CEST