Re: Permission denied error - best way to fix?

2011/2/8, Mike Christensen <mike@kitchenpc.com>:
> Here's the error:
>
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  permission denied for
> relation pantryitems
> pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
>
> Does the user need to be a superuser, or is there some way to GRANT
> this permission (if possible, I don't want this user to be able to
> modify the schema)..
>


this lock need only SELECT privilege.
------------
pasman