Re: Must be owner to truncate?
Stephen Frost <sfrost@snowman.net>
From: Stephen Frost <sfrost@snowman.net>
To: "Jim C. Nasby" <decibel@decibel.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Postgres Hackers <pgsql-hackers@postgresql.org>
Date: 2005-07-07T20:58:03Z
Lists: pgsql-hackers
* Jim C. Nasby (decibel@decibel.org) wrote: > On Thu, Jul 07, 2005 at 01:48:59PM -0400, Tom Lane wrote: > > I don't really agree with the viewpoint that truncate is just a quick > > DELETE, and so I do not agree that DELETE permissions should be enough > > to let you do a TRUNCATE. > > What about adding a truncate permission? I would find it useful, as it > seems would others. That would be acceptable for me as well. I'd prefer it just work off delete, but as long as I can grant truncate to someone w/o giving them ownership rights on the table I'd be happy. Thanks, Stephen