Re: ODBC Driver for Windows

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 03 Mar 2003 09:48:36 -0800
Message-ID: <3E639574.980D9DD3@exesolutions.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 Received on Mon Mar 03 2003 - 11:48:36 CST