Re: [SQL] Has every postgreSQL database own users?

Поиск
Список
Период
Сортировка
От Maarten Boekhold
Тема Re: [SQL] Has every postgreSQL database own users?
Дата
Msg-id 36BACB43.C72B6D1B@tibco.com
обсуждение исходный текст
Ответ на Re: [SQL] Has every postgreSQL database own users?  (Remigiusz Sokolowski <rems@gdansk.sprint.pl>)
Список pgsql-sql
>
> OK, but every database has pg_user table. Why this table is there?
>

They don't have their own copy. The pg_user (and pg_shadow) table are
shared between all databases (think of it as that every database has a
symlink to the 'global' pg_user table).

Maarten

--

Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com

В списке pgsql-sql по дате отправления:

Предыдущее
От: Remigiusz Sokolowski
Дата:
Сообщение: Re: [SQL] Has every postgreSQL database own users?
Следующее
От: Stanimir Stanev
Дата:
Сообщение: date column