Re: truncate table command

Philippe Mendes <EURO.FINANCE_at_wanadoo.fr> wrote in article <341FE624.E63FD5BE_at_wanadoo.fr>...
>
> What is the way to permit to an none dba user to do a 'truncate table'
> on a table of an other user ?
> Which privileges must i give to the user.
> I have try to do an 'grant delete any table' but it has done no change.
>

try
grant drop any table to <user>;

Kevin. Received on Wed Sep 17 1997 - 00:00:00 CDT