pg_dump permissions
Suppose I have a database with a table in it. I try to dump that
database. The user I dump as is not the owner of that table nor does it
have the SELECT permission on that table.
Why can't I do a schema-only dump of that table? I find that I need
SELECT permission on the table, even though my user can happily query
the catalogs.
PostgreSQL version: 7.4
Chris
On 2005-10-19, Christopher Kings-Lynne <chriskl@familyhealth.com.au> wrote:
Suppose I have a database with a table in it. I try to dump that
database. The user I dump as is not the owner of that table nor does it
have the SELECT permission on that table.Why can't I do a schema-only dump of that table? I find that I need
SELECT permission on the table, even though my user can happily query
the catalogs.
pg_dump takes an access share lock on everything it touches, to avoid
having the schema change out from under it.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services