Re: pg_dump and grants to PUBLIC - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: pg_dump and grants to PUBLIC
Date
Msg-id 44637DE2.30109@commandprompt.com
Whole thread Raw
In response to Re: pg_dump and grants to PUBLIC  (Blair Lowe <postgresql@zedemail.ca>)
Responses Re: pg_dump and grants to PUBLIC  (Blair Lowe <postgresql@zedemail.ca>)
List pgsql-general
> 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/



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: string primary key
Next
From: Richard Yen
Date:
Subject: SIGSEGV happens over once a day