Ralph Graulich <maillist@shauny.de> 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