How can user name/table name concatenation be prevented when using ODBC?
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