Re: creating users per database - Mailing list pgsql-general

From Tom Lane
Subject Re: creating users per database
Date
Msg-id 9431.1138561311@sss.pgh.pa.us
Whole thread Raw
In response to Re: creating users per database  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: creating users per database
List 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 by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: help
Next
From: Karsten Hilbert
Date:
Subject: Re: creating users per database