Re: I only want to see five tables with an Oracle user ID?

Yes, I see the usual suspects have been as forthcoming and as helpful as ever.

What I suspect the original poster was after was a way of preventing the display of countless pointless tables whenever a user attempts an ODBC connection to a database. For example, when I, as Scott, attempt to create a linked table in Access, the dialog window I use to accomplish that task includes a listing of some 2000 tables -practically every table that exists in my database, in fact. Yet this particular Scott was granted only 'create table' and 'create session' privileges, so he should have seen (in my particular case) 7 tables listed at most.

So I think our original poster wanted to know if there was a way to limit the list of tables either to what the user actually has rights to or (even better) to a defined list of tables.

Of course, that might not be what the original poster was after at all. But I still think he deserved better than what he got.

As to an answer.... well, I don't know. It's bugged me for years, and I know of no easy way to stop it happening. There's certainly nothing obvious in the ODBC driver dialogs to suppress tables to which you don't have access. But perhaps there is someone out there who can give a useful answer to the original question, instead of a smug one, and then we can all learn something.

Regards
HJR "stinky" <stankonia_at_stunkitystunk.org> wrote in message news:3CC60ABB.205_at_stunkitystunk.org...
> Daniel Morgan wrote:
>
> >The Pig wrote:
> >
> >>Guys,
> >>
> >>Need some help. When connecting via ODBC to an oracle server, I want
> >>to only see let's say five tables. That's it. I don't want to see
> >>the system tables associated with a default user, only certain tables.
> >> How do I do this. I have a Oracle DBA telling me that it can't be
> >>done but I know that it can. Any help would be appreciated. A
> >>detailed answer would be appreciated. Thanks.
> >>
> >>The Pig
> >>
> >
> >I am very tempted to tell you that if you know it can be done even though
> >your DBA tells you it can't that you should not come whining to us in an
> >attempt to make your DBA look bad. You know it can be done ... go do it.
> >
> >In fact, though, you may be right. But not knowing from where you are
> >selecting your list of tables I can't be sure. But one thing I can tell
> >you is that the following query will produce no data dictionary objects
> >and only five tables. Which five is indeterminate.
> >
> >SELECT table_name
> >FROM user_tables
> >WHERE rownum < 6;
> >
> >If you mean the complete contents of five tables ... I can do it ... but
> >I'm going to side with your DBA and not tell you how.
> >
> >Perhaps rephrasing your question with more clarity might help.
> >
>
> Nice. I think you made Sy proud with that post.
>
> >
> >
> >Daniel Morgan
> >
>
>
Received on Tue Apr 23 2002 - 22:57:36 CDT