Re: Permission to TRUNCATE table

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.

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.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"