Instead of ALL_TABLES use USER_TABLES for generating your pick list.
"Mark Sanders" <mark_at_chorlton.co.uk> wrote in message
news:f0da84ec.0303030851.ad124ae_at_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
Received on Mon Mar 03 2003 - 11:01:14 CST
