question re: linked table list

Sorry for the crosspost, but this is both an Oracle and MS question, as it involves odbc drivers from both.

We have a new app being developed, using MS-Access as a front-end to an Oracle 8.1.7 database. We have been playing with both the MS ODBC driver for Oracle and the Oracle ODBC driver.

One thing we have noticed is particularly curious. During the process of defining a linked table, you are presented with a list of objects (tables/view/synonyms) from the underlying data source. This list is different, depending on which odbc driver we are using. Further, in both cases, most of the objects on the list are objects for which the connected user does not have any rights. In our case the odbcuser has only the system privilege of 'create session' and an object privilege of 'select' on 3 particular application tables. That being the case, I would expect the list to contain only those 3 tables, plus all PUBLIC objects, plus the 'ALL_' views.

So my questions are, how are these lists generated, why do they vary by odbc driver, and are there any driver configurations to control what is presented? Received on Wed Mar 05 2003 - 10:58:48 CST