RE: Truncate Privilege

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Mon, 25 Apr 2005 11:53:27 -0400
Message-ID: <017601c549ae$eb4c9910$8459000a@vttaxnet.tax.state.vt.us>

Drop any table is the privilege you need.

Regards,
Ruth

-----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 11: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. =20

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:49 CDT