Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and

Jim Nasby <jnasby@pervasive.com>

From: "Jim C. Nasby" <jnasby@pervasive.com>

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

Cc: Stephen Frost <sfrost@snowman.net>, Bruce Momjian <pgman@candle.pha.pa.us>, Andrew Dunstan <andrew@dunslane.net>, kleptog@svana.org, simon@2ndquadrant.com, gsstark@mit.edu, pg@rbt.ca, zhouqq@cs.toronto.edu, pgsql-hackers@postgresql.org

Date: 2006-01-03T16:38:52Z

Lists: pgsql-hackers

On Tue, Jan 03, 2006 at 11:29:02AM -0500, Tom Lane wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > In general, I do prefer that permissions be seperably grantable.  Being
> > able to grant 'truncate' permissions would be really nice.  Is the only
> > reason such permission doesn't exist due to no one working on it, or is
> > there other disagreement about it?
> 
> Lack of appetite for having forty nonstandard kinds of privilege,
> I suppose ;-)
> 
> Given that we now have roles, it's fairly easy to grant "table owner"
> to trusted people, so the use-case for special privilege types has
> dropped off dramatically IMHO.

Yeah, I hadn't thought about that. I agree; if you trust some process
enough to have MVCC-affecting rights then you should be able to trust it
with full ownership rights.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461