Re: Truncate Permission

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nick Barr <nicky@chuckie.co.uk>
Cc: pgsql-hackers@postgresql.org
Date: 2007-06-10T04:38:30Z
Lists: pgsql-hackers
Nick Barr <nicky@chuckie.co.uk> writes:
> I was looking to start development on the following TODO entry.
> Add a separate TRUNCATE permission

Is there actually a use-case for that?  It seems like mostly pointless
complication to me.  (Note that in the role world, one can effectively
have a table owned by a group, so the real issue here is only whether
there is a point in letting someone truncate a table without having any
other owner-grade permissions for it.)

			regards, tom lane