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 -> Help: Table doesn't belong to anything!

Help: Table doesn't belong to anything!

From: Randal Chapman <Randalc_at_corprasoft.com>
Date: Wed, 14 Oct 1998 16:47:50 -0500
Message-ID: <908419B7607C7E25.60E2F7680270342F.B56EDF7E76179057@library-proxy.airnews.net>


Hi group.

I exported a table to Oracle from Access (yeah, yeah... anyway) to a tablespace named CLDSYS - which belongs to user CLDSYS.

Here is my problem - the table is in there, but I cannot grant select priveleges on it because I can't seem to come up with a logon that can "see" the table. I tried with SYS, SYSTEM, and INTERNAL, and even the CLDSYS logins.

Is there some kind of 'Master' login that can see all objects by default? How do I get this table out of limbo?

Thanks,

_Randal Received on Wed Oct 14 1998 - 16:47:50 CDT

Original text of this message

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