Re: pg_dump and grants to PUBLIC

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: pg_dump and grants to PUBLIC
Дата
Msg-id 44637DE2.30109@commandprompt.com
обсуждение исходный текст
Ответ на Re: pg_dump and grants to PUBLIC  (Blair Lowe <postgresql@zedemail.ca>)
Ответы Re: pg_dump and grants to PUBLIC  (Blair Lowe <postgresql@zedemail.ca>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: string primary key
Следующее
От: Richard Yen
Дата:
Сообщение: SIGSEGV happens over once a day