Re: Web users as database users? - Mailing list pgsql-general

From Rob Sargent
Subject Re: Web users as database users?
Date
Msg-id 28CB89D3-194A-420F-868A-0AFC169EF7E5@gmail.com
Whole thread Raw
In response to Re: Web users as database users?  (Tim Clarke <tim.clarke@minerva.info>)
Responses Re: Web users as database users?
List pgsql-general

> On Sep 20, 2019, at 6:15 AM, Tim Clarke <tim.clarke@minerva.info> 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 by date:

Previous
From: Morris de Oryx
Date:
Subject: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?
Next
From: Tom Lane
Date:
Subject: Re: Web users as database users?