What if you were to create a stored procedure that executes the TRUNCATE TABLE and then give exec priveleges on the SP to that user?

>Hi all:
>
>I'm attempting to issue the TRUNCATE TABLE command from VFP via SQL Pass Thru. When I issue the command, it does not success and I get an error that the user does not have permission to perform this operation on the table in question. In SQL Enterprise Manager, I do not see where I can explicitly grant this permission to a particular user or role.
>
>Will I have to use an administrator level user/role for this? If not, what am I missing?