Re: grant truncate

DELETE is pure SQL , it is known in Data Control Lanaguage and so can be granted as a privilege.
TRUNCATE is unpure SQL, it is an Oracle trick, it is not know in DCL ant cannot be granted.

So long.

j.k. a écrit dans le message <6v2is9$eog$1_at_news.res.ray.com>...
>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.
>
Received on Fri Oct 02 1998 - 10:47:17 CDT