Re: creating users per database

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