Re: Truncate table

Liem T. Duong wrote at 25-Nov-99 12:28:59 on the subject Truncate table:

>Hi everybody !
>I want to grant user the truncate table privilege, according to ORACLE
>book, to execute this command user only needs delete privilege, I still
>have the error message insufficient privileges, any help is
>appreciated.

Hello,
I think you Oracle book is not right. The Oracle 8i documentation states:

"Prerequisites:
 The table or cluster must be in your schema or you must have DROP ANY  TABLE system privilege."

So you will have to resort to the good old delete.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |