Martijn van Oosterhout wrote:
> On Mon, Jun 11, 2007 at 09:40:08AM +0200, Ewald Geschwinde wrote:
>> My problem is that some users don't have access to change the structure but
>> they wanted to delete all data from the table
>> they try truncate - does not work because not the owner
>> so they make a delete from a really big table
>
> Wouldn't it be far more logical to decide that if a user has the
> permissions to do a DELETE FROM table; then they have permission to do
> a TRUNCATE? Why make an additional permission?
Truncate doesn't fire ON DELETE triggers.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com