Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle ODBC connection Ms-Access shows objects from all the schema.

h_kanchanSep 6 2007 — edited Sep 6 2007

Hello
I have a very strange query , We have installed Oracle 9.2.0.4.0 , few of the business users needs to extract data from Oracle in MS access.
Which is fine as we create an Oracle ODBC connection e.g.
ODBC --> Oracle in OraHome92 -->
Data source name : MSORCL
Description --> Oracle to Access
TNS Service name --> ORACLE_TEST
User Id : Test ( user id from which data needs to be extracted )

The I go to Access --> File --> Get External Data --> Link Tables --> File Type ( ODBC Database) --> Machine Data Source --> MSORCL --> And It connects properly .
The issue though is it shows objects from all other schema also in the same connation and as data is vital we do not want unconcerned users to be able to see data from other schemas.

I have created user Test with only Connect role.

You help / advice would be of a great help

Regards

Harshad

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2007

Added on Sep 6 2007

#general-database-discussions

3 comments

573 views