Re: grant truncate

From: Tom Sager <tom.sager_at_lgeenergy.com>
Date: Fri, 2 Oct 1998 14:32:25 -0400
Message-ID: <pV8R1.3800$rm3.2702639125@news.ntr.net>

I'd have to disagree on the GRANT advice. According to the 7.3 SQL Reference the table must be in the user's schema in order to have TRUNCATE privlilege or.... the user must have DELETE ANY TABLE system privilege (according to the books, I've never tried it).

So, if Table ACCOUNT is created in schema SCOTT, and user BOB is granted DELETE on SCOTT.ACCOUNT, user BOB will be able to perform a DELETE but not a TRUNCATE on the table.

TurkBear wrote in message <36160091.10343643_at_news2.mm.com>...
>Truncate is a 'Oracle specific' variant on the 'delete * from ....' command
and
>requires that the user be granted delete rights to the table....
>
>so
>
>' grant delete on table1 to other_users '
>
>will also grant truncate to those users
>
>
>
>
>lien_at_cs.umb.edu (j.k.) wrote:
>
>>Hi,
>>
>>Is there other way that I can solve the problem as below.
>>Any helps would be appricated.
>>
>>grant truncate on table1 to other_users
>> *
>>ERROR at line 1:
>>ORA-00990: missing or invalid privilege
>>
>>
>>thanks.
>>
>
>To reply please remove the 'nospam' part of the address
Received on Fri Oct 02 1998 - 13:32:25 CDT