From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_dump permissions |
Date: | 2005-10-19 12:31:46 |
Message-ID: | slrndlcf5i.2db7.andrew+nonews@trinity.supernews.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2005-10-19, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew - Supernews | 2005-10-19 12:40:40 | Re: Question about Ctrl-C and less |
Previous Message | Kevin Brown | 2005-10-19 11:24:21 | Re: Question about Ctrl-C and less |