Re: TRUNCATE & Version 7.1.3

In article <P5i3Vc1w165w_at_vllyoak.resun.com>, jp_at_vllyoak.resun.com (Jeff Perry)
writes:
|> Would someone with access to version 7.1.3 verify the following:
|>
|> Starting with 7.1.x, a user granted the DELETE privilege to a
|> given table will no longer be allowed to TRUNCATE the table - only
|> the owner of the table will have this privilege.
|>
|>
|> If this is true, we'll be creating gobbs of needless redo logs when
|> we get to 7.1.x. :-(

It is my sad duty to inform you that if you issue the truncate table command in Oracle 7.1.3 and you are not the owner of the table, even though you have been granted the delete privilege, you will receive an ORA-01031: Insufficient privileges error. Received on Fri Nov 25 1994 - 22:25:03 CET