Re: [GENERAL] Limiting DB access by role after initial connection?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: [GENERAL] Limiting DB access by role after initial connection?
Дата
Msg-id 20170610003843.GA10159@wolff.to
обсуждение исходный текст
Ответ на [GENERAL] Limiting DB access by role after initial connection?  (Ken Tanzer <ken.tanzer@gmail.com>)
Ответы Re: [GENERAL] Limiting DB access by role after initial connection?
Список pgsql-general
On Thu, Jun 08, 2017 at 22:37:34 -0700,
  Ken Tanzer <ken.tanzer@gmail.com> wrote:
>
>My approach was to have the initial connection made by the owner, and then
>after successfully authenticating the user, to switch to the role of the
>site they belong to.  After investigation, this still seems feasible but
>imperfect.  Specifically, I thought it would be possible to configure such
>that after changing to a more restricted role, it would not be possible to
>change back.  But after seeing this thread (

How are you keeping the credentials of the owner from being compromised? It
seems if you are worried about role changing, adversaries will likely also
be in a position to steal the owner's credentials or hijack the connection
before privileges are dropped.


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

Предыдущее
От: armand pirvu
Дата:
Сообщение: Re: [GENERAL] Vacuum and state_change
Следующее
От: Steven Grimm
Дата:
Сообщение: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection