Re: Truncate Permission

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