i need a user to be able to truncate a couple of other user's tables.
granting delete on those tables doesn't work. the only way i've found it works is granting drop any table to the user, but i don't find that safe. is there any other way??