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

Guys,

Thanks for your help....seriously. You are exactly right on what I am trying to do. For some reason, when you link to an oracle server, using the Microsoft Oracle driver you get the pop up window which lists every table in the whole server. Let's say there are 200 system tables and 100 tables that actually contain data for your company. I am trying to get the ODBC driver to only see 5 tables that contain data that I want. I do not want a user to see every table except the ones that I choose for him to see. It's actually not that, it's that a shipping program that we are using that connects via odbc attempts to "attach" to all tables via ODBC. When you are looking at 2000 tables it crashes the system. Trust me, I know this is the problem of the shipping system and not orcle but I know it has been done. The simple prob is that I can't get in contact with the DBA who did since his on vacay for two weeks. I was just hoping that someone here knew or has come across this problem. Thanks.

The Pig

oratune_at_msn.com (David Fitzjarrell) wrote in message news:<32d39fb1.0204240546.1cd62a0b_at_posting.google.com>...
> 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 - 18:38:44 CDT