Re: pg_dump and grants to PUBLIC

> select relname from pg_class where oid = 17736;
> relname
> -----------------
> bbs_auth_access
> (1 row)
>
> phpbb_mainlandpc=> \q
>
> To access this user's table, I can be logged on as anyone, and that is
> expected in SQL when there are public grants.
>
> I am not expecting to get everyone else's stuff when I run pg_dump, only
> the stuff in their schema.

O.k. if you are actually using schemas, then pass the schema parameter
to pg_dump and you won't get other information.

Joshua D. Drake

>
> TTYL,
> Blair.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/