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