Re: Users/Roles do not align.

Поиск
Список
Период
Сортировка
От Jürgen Purtz
Тема Re: Users/Roles do not align.
Дата
Msg-id ae68a0ba-9a20-bbab-8964-4b66c459e4c3@purtz.de
обсуждение исходный текст
Ответ на Re: Users/Roles do not align.  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Users/Roles do not align.  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
> There's a few things wrong about this part anyway- namely that we've got
> FDWs now, and there's certainly other cluster-wide things that exist
> beyond the specific items listed, so I wonder if perhaps we should just
> stop trying to list everything here.

Inspiring answer! After some inquiry I became aware, that we do not have 
only 2 levels of 'belong-to' but 3: tables, views, operators, and much 
more objects belong to a schema; schemata, extensions (e.g. FDW), and 
more(?) belong to a database; databases, roles, tablespaces, and more 
belong to a cluster. Two aspects of 'belong-to' are: object names are 
unique within their level, and objects are automatically known 
everywhere within their level.

Information about such dependencies and their consequences is spread 
across different chapters of the documentation and the System Catalog. 
Of course the chapter about roles/users is not suitable to explain the 
details. But it's important to know the hierarchy, it shut be summarized 
somewhere.

Kind regards,  J. Purtz





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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Documentation: 21.5. Default Roles
Следующее
От: PG Doc comments form
Дата:
Сообщение: Examples required in || 5.10. Table Partitioning