Re: creating users per database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: creating users per database
Дата
Msg-id 9431.1138561311@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: creating users per database  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: creating users per database  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> Aha ! Indeed, the 7.4 documentation wasn't clear enough on
> that (for me):

> "... The value samegroup specifies that the requested user
>  must a member of the group with the same name as the
>  requested database. ..."

> Might this be amended to say "... a member of the *database*
> group with ..." ?

The 8.1 documentation uses the term "role", which seems unlikely to be
confused with Unix groups:

: database
:
:      Specifies which database names this record matches. The value all
:      specifies that it matches all databases. The value sameuser
:      specifies that the record matches if the requested database has the
:      same name as the requested user. The value samerole specifies that
:      the requested user must be a member of the role with the same name
:      as the requested database. (samegroup is an obsolete but still
:      accepted spelling of samerole.) Otherwise, this is the name of a
:      specific PostgreSQL database. Multiple database names can be
:      supplied by separating them with commas. A separate file containing
:      database names can be specified by preceding the file name with @.

Good enough?

            regards, tom lane

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

Предыдущее
От: "Raymond O'Donnell"
Дата:
Сообщение: Re: help
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: creating users per database