Nothing. Truncate is a DDL command, not DML. As such synonyms don't count.=20 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Larry Hahn [mailto:lhahn_60@xxxxxxxxx]=20 Sent: Friday, December 03, 2004 2:43 PM To: Oracle-L@xxxxxxxxxxxxx Subject: Truncate another users table List, I am running version 8.1.7 on Sun. I am trying to allow a user (A) to truncate another users (B) table. I have already given the DROP ANY TABLE right to A, and made a public synonym for the table owned by B.=20 I can't do the truncate if I just give the table name, but if I put the owner first (truncate table A.<tablename>) it works. What have I missed? Because the truncate command that I ultimately need to run is buried in the vendors code, I am not able to create and execute the stored procedure that I have seen suggested here on the list in the past.=20 Thanks in advance for any help. Larry Hahn =09 __________________________________=20 Do you Yahoo!? Send holiday email and support a worthy cause. Do good. http://celebrity.mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l