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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insufficient privelege as system user ???

Re: Insufficient privelege as system user ???

From: Diane <Diane_at_coalole.demon.co.uk>
Date: Thu, 11 Feb 1999 19:34:56 +0000
Message-ID: <wJnGFEAgDzw2IwvQ@coalole.demon.co.uk>


In article <79v2vh$4u2$1_at_nnrp1.dejanews.com>, sks_at_scminc.com writes
>
>
>Greetings,
>
> What would cause an "insufficient privelege" problem
>while working as the "system" user? In SQLPLUS
>I'm doing a "desc table_name" where the table is actually
>a synonym. For some of the tables I get the above error
>message.
> My guess would be that that table didn't actually exist.
>
> Am I missing something fundamental?
>
>Thanks,
> Sujay S.
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
There was a bug in early versions of Oracle 8 which meant desc tablename didn't work but I don't think this was the message it gave. You say thyou're actually doing desc synonym - who owns the synonym? (look in dba_objects) If it's a private synonym you may not have privileges to use it. (I'm going to try this one out tomorrow) --
Diane Received on Thu Feb 11 1999 - 13:34:56 CST

Original text of this message

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