Re: Permission to TRUNCATE table

Brian Peasland wrote:

> TRUNCATE is not a DML command. Therefore, a DML privilege like DELETE
> will not suffice. TRUNCATE is a DDL command. IIRC, one needs the ability
> to DROP that table to be able to truncate it.

Thanks to all for the assist. I had found the DROP ANY TABLE info but was reluctant to give this user that much dynamite to play with.

Daniel's idea about doing it via proc seems the best long term solution. Short term the user just has to tolerate the extra time for DELETE to work. It's rarely more than 1000 rows, no triggers on them, etc. so I'm not going to lose any more sleep on this one.

>
> HTH,
> Brian
>
> Elmo wrote:
>

>>I have set up a ROLE and assigned permissions to INSERT, SELECT,
>>DELETE, and UPDATE tables to that ROLE.
>>
>>I have a user with that ROLE.
>>
>>The user cannot TRUNCATE TABLE_NAME but can DELETE FROM TABLE_NAME.
>>
>>What permission/rights needs to be granted in order to TRUNCATE the
>>table?
>>
>>Anyone with a clue?  I'm fresh out.