Horton

Re: Truncate Permission

Stephen Frost <sfrost@snowman.net>

View thread View on postgr.es
From: Stephen Frost <sfrost@snowman.net>
To: Zeugswetter Andreas ADI SD <ZeugswetterA@spardat.at>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>, Martijn van Oosterhout <kleptog@svana.org>, 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-11T11:49:20Z
Lists: pgsql-hackers 
* Zeugswetter Andreas ADI SD (ZeugswetterA@spardat.at) wrote:
> 
> > > 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.

Nope, it doesn't follow MVCC rules properly either.  It really needs to
be a seperate permission.

	Thanks,

		Stephen