Re: Permission question

Remember, truncate is a DDL and not a DML...This may somewhat explain the drop table priv..
Michael Serbanescu <mserban_at_postoffice.worldnet.att.net> wrote:

>The DROP ANY TABLE system privilege.
>
>Hope this helps.
>
>
>
>
>Michael Serbanescu
>--------------------------------------------------------------------------
>Hope Jim Finch wrote:
>>
>> It is my understanding that any user with Delete privs on a table can
>> truncate it. I have users with select, update, insert, delete privs on a
>> table. They can do all (select, update, delete and insert) but not
>> trucate. They get insificient priv. What priv are they lacking.
>>
>> Jim Finch
>>
>> email to jfinch_at_calibersys.com
Received on Thu Feb 26 1998 - 00:00:00 CST