On 02/08/2011 10:57 AM, Mike Christensen wrote:
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)..
Mike
pg_dump is an admin function so it will need to run as a role that can
touch all requested objects and take action. For this particular case
you could GRANT SELECT on that table to the restricted user. The trouble
being is that this turns into a game of Whack-a-Mole fairly quickly.
This is one of those situations where taken a long view on your
permissions scheme will pay dividends.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
