Horton

Re: Truncate Permission

Martijn van Oosterhout <kleptog@svana.org>

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

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.