Horton

Re: Truncate Permission

Zeugswetter Andreas DCP SD <zeugswettera@spardat.at>

View thread View on postgr.es
From: "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
To: "Heikki Linnakangas" <heikki@enterprisedb.com>, "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:44:09Z
Lists: pgsql-hackers 
> > 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.

Yes, but it would imho be ok if there are'nt any on delete triggers on
the table.

Andreas