Re: Synonym tables queries for ORACLE through ACCESS

On Thu, 31 Dec 1998 20:48:25 GMT, muhammadb_at_epenergy.com wrote:

>Oracle has a security feature that you can refernce original tables in the
>databse through synonym tables in your query. This enables the secrecy of the
>original table .

Synonyms are not a security feature. They exist as a convenience, and to insulate you from having to code a specific schema.tablename in your queries. It's quite easy to find out the table to which a synonym points.

<snip>
>The trouble
>I'm having is that when i hook ACCESS to ORACLE . here is the catch 22 . I
>can only run the query for the tables I see in my tables tab in ACCESS. But
>if the original tables are hidden in oracle , they won't be visible in
>access. If they are not visible I can't run the query. How can i refernce to
>the synonym tables in ORACLE through my ACCESS query .

I understand this problem. The same issue exists when we use Powerbuilder to connect to Oracle. Is it possible for you to just type in the SQL query directly, instead of using the GUI query builder provided by Access? That way you could just type in the synonym name.

I wish I had a better answer for you. With our PB app, we just go straight to the "Show Query as Syntax" screen, and type in the SQL as we want it.

regards,

Jonathan Received on Fri Jan 01 1999 - 18:43:30 CST