On Tue, Jan 03, 2006 at 11:29:02AM -0500, Tom Lane wrote: > Stephen Frost <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend