Truncate Privilege
- From: "Bellows, Bambi" <bbellows@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 25 Apr 2005 09:53:13 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Burton, Laura
Sent: Monday, April 25, 2005 10: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. =3D20
Thank you, Laura
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
