Postgres Pro
Downloads
Home   >   mailing lists

LOCK TABLE permission requirements - Mailing list pgsql-general

From Florian Weimer
Subject LOCK TABLE permission requirements
Date
Msg-id 82oc1gj1u3.fsf@mid.bfk.de
Whole thread Raw
Responses Re: LOCK TABLE permission requirements  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-general
Tree view 
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@bfk.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

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Real type with zero
Next
From: Emrul Islam
Date:
Subject: Re: Multi-tenancy in Postgres