Re: How to grant truncate privilege

>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
>
>

Kiran,
  The permission required for a user to be able to truncate another users table is the drop any table system privilege.
HTH,
  Rob Received on Thu Jun 15 2000 - 00:00:00 CDT