Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!diablo.theplanet.net!news.indigo.ie!not-for-mail Reply-To: "Telemachus" From: "Telemachus" Newsgroups: comp.databases.oracle.server References: Subject: Re: ODBC Driver for Windows Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Mon, 3 Mar 2003 17:01:14 -0000 NNTP-Posting-Host: 62.77.170.89 X-Complaints-To: abuse@eircom.net X-Trace: news.indigo.ie 1046710875 62.77.170.89 (Mon, 03 Mar 2003 17:01:15 GMT) NNTP-Posting-Date: Mon, 03 Mar 2003 17:01:15 GMT Organization: Eircom.Net http://www.eircom.net Xref: newsfeed1.easynews.com comp.databases.oracle.server:178277 X-Received-Date: Mon, 03 Mar 2003 10:01:08 MST (news.easynews.com) Instead of ALL_TABLES use USER_TABLES for generating your pick list. "Mark Sanders" wrote in message news:f0da84ec.0303030851.ad124ae@posting.google.com... > We teach Oracle to undergraduates. > > I want to provide an ODBC driver so they can import their Oracle > tables into Access. > > Can I fix things so that the list of tables they can import only > includes their own tables??? > > At the moment it also contains hundreds of views to which they - as > members of PUBLIC - have access. > > Obviously this does not stop them finding and selecting their own > tables, but this gives so much scope for confusion and errors that I'm > trying to avoid it. > > Thanks for all help