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

Heh, jerk off. It's not my DBA. It's simply a DBA who won't allow a customer to hook a system that has trouble with ODBC connections that show 500 tables. The point being, if you create a user that when logged in using the Microsoft ODBC driver, and that user only can view the 5 tables that you want to see then he would be goog to go. If I fucking new how to do it I would have done it myself instead of getting a fucked up response from a jerk off like you. Next time just don't post...your an idiot who gives this news group a bad name.

The Pig

Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3CC5D0FC.2655EC35_at_exesolutions.com>...
> 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.
>
> Daniel Morgan
Received on Tue Apr 23 2002 - 22:21:47 CDT