Re: Question About Roles

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Question About Roles
Дата
Msg-id 53B417AC.30301@aklaver.com
обсуждение исходный текст
Ответ на Question About Roles  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Question About Roles
Список pgsql-general
On 07/02/2014 06:17 AM, Rich Shepard wrote:

  Or, is that
> automatic if the role is included in the Users table?

To follow up on my previous post. If you have your own user table,
having a user in that table with the same name as one of the Postgres
role does not mean they pick up the Postgres role permissions. The
permissions apply to the role that the user connects as in the
connection parameters(or is changed to once connected). This is why
something like Django has it owns permissions system. The framework
connects to the database as a single role(which has sufficient Postgres
permissions) and when users log in they are tracked by the Django
permissions not by the Postgres system.

>
> Rich
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: How can I replace the year of the created_at column with the current year dynamically ?
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Question About Roles