Horton

Re: Truncate Permission

Heikki Linnakangas <heikki@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Martijn van Oosterhout <kleptog@svana.org>
Cc: Ewald Geschwinde <egeschwinde@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Nick Barr <nicky@chuckie.co.uk>, pgsql-hackers@postgresql.org
Date: 2007-06-11T09:04:41Z
Lists: pgsql-hackers 
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