Re: Help on truncate table
From: Christoph Glanz <christoph.glanz_at_lhsystems.com>
Date: 25 Nov 1999 13:16:13 GMT
Message-ID: <slrn83qdkr.9l.christoph.glanz_at_wnt-hamlsy0143.lrs.ham.dlh.de>
Date: 25 Nov 1999 13:16:13 GMT
Message-ID: <slrn83qdkr.9l.christoph.glanz_at_wnt-hamlsy0143.lrs.ham.dlh.de>
Hi Liem,
On 25 Nov 1999 11:31:06 GMT, Liem T. Duong <af193_at_FreeNet.Carleton.CA> wrote:
>
>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.
The user needs the "DROP ANY TABLE" privilege :-(
Regards
Christoph Glanz
-- Christoph Glanz Tel: +49-40-5070-7675 Lufthansa Systems AS GmbH Fax: +49-40-5070-7880 Schuetzenwall 1 Internet: http://www.lhsystemsas.de D - 22844 NorderstedtReceived on Thu Nov 25 1999 - 14:16:13 CET