As jurij pointed out you would require to give drop any table privilege to the user. That would allow him to truncate the tables.


Sam