On Wed, Jun 29, 2011 at 7:48 AM, Florian Weimer <fweimer(at)bfk(dot)de> wrote:
> I've been looking around in the 9.0 documentation, but couldn't find the
> permission requirements for LOCK TABLE (in particular, LOCK TABLE IN
> SHARE MODE). From the source, you need at least one of UPDATE, DELETE
> or TRUNCATE.
> Is there a reason why the INSERT privilege is not sufficient for LOCK
> TABLE, or is this just an oversight?
The comments on this thread outline some reasons the permissions for
LOCK TABLE are setup the way they are:
Basically, if you have UPDATE, DELETE, or TRUNCATE privileges you can
potentially lock out competing sessions on a table, similar to what
some forms of LOCK TABLE would do; just having INSERT privileges
doesn't necessarily give you that power.
In response to
pgsql-general by date
|Next:||From: Craig Ringer||Date: 2011-06-30 00:39:40|
|Subject: Re: Windows x64 : How do I get OSSP-UUID.sql contrib for
|Previous:||From: David Johnston||Date: 2011-06-29 22:31:14|
|Subject: Re: Real type with zero|