Search Postgresql Archives

Re: creating users per database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux