Dereck L. Dietz wrote:
> 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?
Truncate is DDL not DML. You appear to have not provided the appropriate
priv which is DROP ANY TABLE. One I would highly recommend you never
grant to anyone.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Apr 05 2006 - 13:11:13 CDT
