Re: TRUNCATE & Version 7.1.3

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. :-(

According to the Oracle7 Server Documentation Addendum (9-11) you need the DROP ANY TABLE system privilege to TRUNCATE a table or cluster not in your schema.

kind regards,

Andrevw

-- 
Andre van Winssen <andrevw_at_ideta.nl>		
Ideta b.v., Frankemaheerd 6, 1102 AN Amsterdam, the Netherlands