I know this is not necessarily easy but you do really need to go back to the
vendor of the shipping program and ask for a patch. Hashing all_catalog so
that it doesn't show all the catalog is not an option any DBA I've ever come
across would countenance.
Thanks to David for the all_catalog tip that does seem to be the view that
is being used.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"The Pig" <iamdakidd_at_yahoo.com> wrote in message
news:81f0f183.0204241538.1ba0b8eb_at_posting.google.com...
> 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 Thu Apr 25 2002 - 03:12:51 CDT
