From: Jürgen Purtz <juergen@purtz.de>
To: pgsql-docs@lists.postgresql.org
Cc: jbird@nuna.com
Subject: Re: Users/Roles do not align.
Date: Tue, 4 Feb 2020 07:39:50 +0100
Message-ID: <2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de> (raw)
In-Reply-To: <158057750885.1123.2806779262588618988@wrigleys.postgresql.org>
References: <158057750885.1123.2806779262588618988@wrigleys.postgresql.org>
> Based on this, I believe Section 5.9 should read:
> `A PostgreSQL database cluster contains one or more named databases. Roles
> are shared across the entire cluster, but no other data is shared across
> databases. Any given client connection to the server can access only the
> data in a single database, the one specified in the connection request.`
imo the following is a more precise wording:
'A cluster contains three or more named databases ('template0',
'template1', 'postgres', ...). Roles, which are users or groups, see
Chapter 21, - as well as database names and tablespace definitions - are
shared across the entire cluster. No other data is shared across
databases or schemas. Any given client connection to the server can
access only the data in a single database, the one specified in the
connection request. If it has the necessary privileges, the connection
can access all schemas within this database.'
And the last sentence of the paragraph behind 'Note' shall be extended,
because schemas are rigidly separated from each other - only the access
to different schemas is easily done from a single connection.
'Unlike _access to_ databases, _access to_ schemas is not rigidly
separated: a _connection_ can access objects in any of the schemas in
the database they are connected to, if they have privileges to do so.'
J. Purtz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: juergen@purtz.de, pgsql-docs@lists.postgresql.org, jbird@nuna.com
Subject: Re: Users/Roles do not align.
In-Reply-To: <2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox