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 -> PUBLIC SYNONYM Difficulty

PUBLIC SYNONYM Difficulty

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 04 Apr 2006 22:05:10 GMT
Message-ID: <q4CYf.11802$tN3.10050@newssvr27.news.prodigy.net> 





I've created a database and, for some reason, I'm having problems with my
PUBLIC SYNONYMS.


I can person an insert statement on a table using the SYSTEM account on a
different schema using the synonym but if I try to TRUNCATE I get an error
message saying the table doesn't exist.  However, if I connect to the schema
the table belongs to then the TRUNCATE works just fine using the synonym.



Any ideas what I'm doing wrong?
Received on Tue Apr 04 2006 - 17:05:10 CDT












Original text of this message













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