Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I only want to see five tables with an Oracle user ID?

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

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 23 Apr 2002 20:35:05 -0500
Message-ID: <uk7qx3e3j.fsf@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...

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Tue Apr 23 2002 - 20:35:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US