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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org