Re: [GENERAL] LOCK TABLE permission requirements

2011-06-30 Thread Florian Weimer
* Josh Kupershmidt: On Wed, Jun 29, 2011 at 7:48 AM, Florian Weimer fwei...@bfk.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

[GENERAL] LOCK TABLE permission requirements

2011-06-29 Thread Florian Weimer
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

Re: [GENERAL] LOCK TABLE permission requirements

2011-06-29 Thread Josh Kupershmidt
On Wed, Jun 29, 2011 at 7:48 AM, Florian Weimer fwei...@bfk.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