| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Truncate another users table
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_at_yahoo.com]=20
Sent: Friday, December 03, 2004 2:43 PM
To: Oracle-L_at_freelists.org
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
 |
 |