DJ wrote:
> "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
>
>
Nope. Just as simple as can be.
Received on Wed Oct 22 2003 - 06:42:57 CDT
