How can user name/table name concatenation be prevented when using ODBC?

From: Ronald van der Burg <ronald_at_mix004.nwg.dec.com>
Date: 1995/12/01
Message-ID: <49mfp0$a55_at_mrnews.mro.dec.com>#1/1


Hi,

Thanks for reading.

It was possible to create a database, and share tables and public synonyms with users. For a novice Oracle user as I am, Your input via the net was great help, however I have another problem.

Oracle concatenates user names and table names, for example user "diane" and table "product_table" becomes "diane.product_table". When the database is accessed via ODBC, I would like to access tables using table names (or public synonyms) only.

I tried public synonyms. This works if a user logs in into Oracle directly. But if access is done via ODBC, these synonyms don't show up in a normal way. They are only visible if system names are requested also. But system names are not visible if you try to use attached tables with MS-Access 2.0.

Does any one know a solution for this problem?

Thanks in advance!

Ronald Received on Fri Dec 01 1995 - 00:00:00 CET

Original text of this message