pg_dump privileges - Mailing list pgsql-admin

From Mark Lubratt
Subject pg_dump privileges
Date
Msg-id 83A6F4CE-5650-11D8-9324-000A9579AF50@indeq.com
Whole thread Raw
Responses Re: pg_dump privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hello,

I'll get right to the point.

I'd like to create a user for my pg_dump backup process.  I'd like that
user to have only the privileges required to run pg_dump.  I have a
language, a function and sequences, views and tables in my schema.
What privileges are needed for pg_dump to run in addition to USAGE (for
the language), EXECUTE (for the function) and SELECT (tables, views and
sequences)?

Thanks!
Mark


pgsql-admin by date:

Previous
From: Marek Lewczuk
Date:
Subject: Re: Removing OIDs
Next
From: Chris Gamache
Date:
Subject: Re: Alternative to "Money" ...