RE: Truncate Privilege

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <BurtonL@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 25 Apr 2005 11:53:27 -0400

Drop any table is the privilege you need.  

Regards,
Ruth

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Burton, Laura
Sent: Monday, April 25, 2005 11:47 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Truncate Privilege


Can someone tell me what privilege is needed for a user to truncate a
table that is not owned by that user?

I have looked at Metalink and it states the Drop Any Table privilege,
but this doesn't work either.  The user can select, insert, and even
delete from the table. =20

Thank you, Laura

--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Other related posts: