Truncate Privilege

From: Bellows, Bambi <bbellows_at_usg.com>
Date: Mon, 25 Apr 2005 09:53:13 -0600
Message-ID: <20942DC78B4BBB49A1567DB0E5E81EB513CC75DB@dctr-exbe-001.usg.net>

Laura --

This has been a historical problem. There are ways to work around the restriction, but generally involve a temporary grant of greater power than is necessary to perform the function.

Best wishes,
Bambi.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Burton, Laura Sent: Monday, April 25, 2005 10:47 AM
To: oracle-l_at_freelists.org
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. =3D20

Thank you, Laura

--

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

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 25 2005 - 11:57:31 CDT