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