RE: Truncate another users table

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <lhahn_60@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 3 Dec 2004 15:00:10 -0500

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

Other related posts: