Re: Permission to TRUNCATE table

From: DJ <nospamplease_at_goaway.com>
Date: Tue, 21 Oct 2003 22:24:12 +0100
Message-ID: <2uhlb.548$vr5.250@newsfep4-winn.server.ntli.net>

"Elmo" <DoNoSpam_at_NoSpam.org> wrote in message news:bn45d8$19s6$1_at_f04n12.cac.psu.edu...
> 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.
>

is it through a procedure? could well need to explicitly grant truncate to that user Received on Tue Oct 21 2003 - 16:24:12 CDT