Melvin, * Melvin Davidson (melvin6925@xxxxxxxxx) wrote: > Simply put, giving access to a schema DOES NOT automatically give access to > any table in the schema. So if you want a specific user ( or role) to be > able to read (or pg_dump) all tables in the schema, then you must GRANT > SELECT of all tables in that schema to the user (or role). That's not the question at hand, however. He's not asking about dumping out the records of the table but rather about pulling out the schema, which any user can do, regardless of their permissions on the tables. There's no need to 'grant select' access on a table, or even to 'grant usage' on the schema, simply issue queries against the catalog. pg_dump is going beyond what's strictly necessary for a schema-only dump though, it's trying to lock all of the tables too, which really isn't necessary in this case. Thanks, Stephen
Attachment:
signature.asc
Description: Digital signature
