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

I believe the problem stems from the ALL_CATALOG view, which the ODBC driver queries to provide a table list. Any public synonyms are shown in this list, as well as tables the given user either owns or has access to. So, the user is not seeing the names of tables he/she cannot access but public synonyms he/she DOES have access to. The problem arises when accessing the public synonym, since permissions for the given user on the underlying object do not exist. (Tracing the ODBC calls to a log file certainly helped in this regard, revealing the ALL_CATALOG view access to my prying eyes.)

Without re-writing the ALL_CATALOG view to eliminate the public synonyms or eliminating the public synonyms altogether (not a valid option in my book) I can't see any method of 'pruning' the output to only the tables the user owns or has direct access to.

David Fitzjarrell

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<uk7qx3e3j.fsf_at_rcn.com>...
> On 23 Apr 2002, iamdakidd_at_yahoo.com 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.
>
> What five tables are you talking about?
>
> What do you mean by "seeing"? Are you using some gui interface like
> Toad, or SQLProgrammer and you want the ODBC connection to limit your
> selection? I would side with the DBA on this one.
>
> > 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.
>
> Well, you are confident that it can be done but you want a detailed
> answer? Hm...
Received on Wed Apr 24 2002 - 08:46:26 CDT