Re: Schema/user/role

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Schema/user/role
Дата
Msg-id CAKFQuwYyKyY3afn3fRj=j4+_SrarbKAU0qzmhRKS1HQUzumgFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Schema/user/role  (DAVID ROTH <adaptron@comcast.net>)
Ответы Re: Schema/user/role  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general
On Mon, Mar 20, 2023 at 9:13 AM DAVID ROTH <adaptron@comcast.net> wrote:
Is there any good reference to explain the best usage of each of these structures.
I am coming from Oracle.  What is the best analog to Oracle's "user".

A schema is a namespace mechanism for objects.  It has no relationship to roles aside from the possibility, if you so choose, to define a schema to have the same name as a role, in which case that schema becomes parts of that role's default search_path.

There is no low-level difference between role and user.  A user is a role with the login privilege.

David J.

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Schemas and Search Path
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Schema/user/role