Re: How to grant truncate privilege

From: Chandra Pabba <Chandra.Pabba_at_sabre.com>
Date: 2000/06/19
Message-ID: <394E554F.AF176664@sabre.com>#1/1

Kiran!

There is no TRUNCATE privilege associated with tables. You may have to grant DELETE on table EMPLOYEE as the owner of the table, or as any user, who have been granted such privileges with GRANT OPTION.

HTH Chandra

kiran_mamidi_at_my-deja.com wrote:

> Hi Guys,
> I have the following question. Could someone please help me.
> I would like to grant user: SCOTT, truncate a table 'EMPLOYEE'
> which is owned by another user 'XYZ'. How can grant truncate to SCOTT
> on XYZ.EMPLOYEE table.
>
> Thanks in advance.
>
> Kiran
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jun 19 2000 - 00:00:00 CDT