Re: Web users as database users?

Поиск
Список
Период
Сортировка
Искать
От
Rob Sargent
Тема
Re: Web users as database users?
Дата
Msg-id
28CB89D3-194A-420F-868A-0AFC169EF7E5@gmail.com
Ответ на
Список
Дерево обсуждения
Web users as database users? David Gallagher <1extrafact@gmail.com>
Re: Web users as database users? Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: Web users as database users? Tim Clarke <tim.clarke@minerva.info>
Re: Web users as database users? Rob Sargent <robjsargent@gmail.com>
Re: Web users as database users? Tom Lane <tgl@sss.pgh.pa.us>
Re: Web users as database users? Michael Lewis <mlewis@entrata.com>
Re: Web users as database users? Tom Lane <tgl@sss.pgh.pa.us>
Re: Web users as database users? Stephen Frost <sfrost@snowman.net>
Re: Web users as database users? Andrei Zhidenkov <andrei.zhidenkov@n26.com>


> On Sep 20, 2019, at 6:15 AM, Tim Clarke  wrote:
> 
>> On 20/09/2019 12:50, David Gallagher wrote:
>> Hi - I’m working on a database that will be accessed via a web app.
>> I’m used to a setup where there is one account/role that the app would
>> use to access the database, but in my current scenario I’m interested
>> in row level security and auditing enforced by the database. In this
>> scenario, would it make sense to have a user account on the database
>> to mirror the user account from the web app? Is that an unusual practice?
> 
> 
> Not at all, we're doing it
> 
> 
> Tim Clarke
> 
But you likely want a many-to-one mapping of actual user to permission group

В списке pgsql-general по дате отправления
От: Morris de Oryx
Дата:
От: Tom Lane
Дата:
FAQ