>>>Does a user need FULL CONTROL permissions to pack a table?
>>
>>At the operating system level, read, write, and delete permissions should be enough. At least, I suspect that delete would have to be included, since the table is copied to another file (the non-deleted records, that is), and then the old file is deleted.
>>
>>A user also needs exclusive access; no other user may be using the table at the same time.
>
>It's the delete permissions I am wary of.
Ummm... yes, of course.
You might try it without the delete permission.
Also, since a PACK usually needs to be done perhaps once a month, you can give certain super-privileges only to certain users who will do the maintenance.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
