Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!news.webusenet.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: ODBC Driver for Windows Date: Mon, 03 Mar 2003 09:48:36 -0800 Organization: EXE Message-ID: <3E639574.980D9DD3@exesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@splish28.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 30 Xref: newsfeed1.easynews.com comp.databases.oracle.server:178284 X-Received-Date: Mon, 03 Mar 2003 10:49:15 MST (news.easynews.com) Mark Sanders wrote: > 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 Your post is a bit frightening. First because you are using MS Access to teach Oracle which makes me fear your students will learn nothing and second (and please pardon me for saying so) the appearance that the instructors don't know Oracle either based on the above question. If this is an academic institution, rather than a for-profit, contact me off-line and I will help you. Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp