LOCK TABLE permission requirements

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: LOCK TABLE permission requirements
Date: 2011-06-29 11:48:04
Message-ID: 82oc1gj1u3.fsf@mid.bfk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emrul Islam 2011-06-29 11:53:52 Re: Multi-tenancy in Postgres
Previous Message Grzegorz Jaśkiewicz 2011-06-29 11:43:50 Re: Real type with zero