Re: Users/Roles do not align.

Поиск
Список
Период
Сортировка
От Jürgen Purtz
Тема Re: Users/Roles do not align.
Дата
Msg-id 2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de
обсуждение исходный текст
Ответ на Users/Roles do not align.  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: Users/Roles do not align.  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-docs

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

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

Предыдущее
От: Jürgen Purtz
Дата:
Сообщение: Re: Shrinking SVG (Again)
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Documentation: 21.5. Default Roles