Skip site navigation (1) Skip section navigation (2)

Re: patch: Add a separate TRUNCATE permission

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: patch: Add a separate TRUNCATE permission
Date: 2008-07-29 11:08:44
Message-ID: 20080729110844.GL16005@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Peter Eisentraut (peter_e(at)gmx(dot)net) wrote:
> Am Sunday, 27. July 2008 schrieb Robert Haas:
> > Here's a patch implementing the TODO item "Add a separate TRUNCATE
> > permission".  Hopefully I found all the bits that needed to be
> > modified to make this work.
> 
> Looks very good to me.

We've been through this before, I believe..  The concern is that it
chews up another bit in the acl structure, leaving not a huge number
left.  My suggested approach to fixing this was to split the "grantable"
bits up from the regular usage bits.  That's, unfortunately, a
non-trivial amount of work, however.

Perhaps just having a plan for how we would increase the number of
available bits would be enough to go ahead and add this option though?
I'd certainly like to see a truncate permission, I wrote a patch for it
myself back in January of 2006.  That thread starts here:

http://archives.postgresql.org/pgsql-patches/2006-01/msg00028.php

I think someone else submitted a patch for it last year too, actually.
	
	Thanks,

		Stephen

In response to

Responses

pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2008-07-29 11:24:05
Subject: Re: Python 2.5 vs the buildfarm
Previous:From: Asko OjaDate: 2008-07-29 10:56:19
Subject: Re: [PATCH] "\ef <function>" in psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group