Ralph Graulich <[EMAIL PROTECTED]> writes: > The way the question occured while creating a user allowed to pg_dump > certain databases, but not allowed to do anything else. That way I only > granted SELECT privileges on the tables to that user, but that didn't > work, as pg_dump wants to lock the table.
Huh? pg_dump only takes ACCESS SHARE lock, which requires only SELECT privileges. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org