Re: Securing records using linux grou permissions

From: David Gauthier <davegauthierpg(at)gmail(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Securing records using linux grou permissions
Date: 2019-10-15 17:10:13
Message-ID: CAMBRECB=12dpQSREXmRHeeayXjY_FZG5cmNddetHsJBmqX52pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok, thanks.
I was hoping there was a way to integrate the user/permissions/groups in
linux with the PG permissions functionality.

On Tue, Oct 15, 2019 at 12:32 PM Michael Lewis <mlewis(at)entrata(dot)com> wrote:

> It sounds like you want row level security-
> https://www.postgresql.org/docs/9.6/ddl-rowsecurity.html
>
> But, you will need to define separate roles on the database and ensure
> that the users and connecting with separate roles. The db can't magically
> know about the permissions on the OS side.
>
>>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-10-15 17:18:13 Re: Securing records using linux grou permissions
Previous Message Michael Lewis 2019-10-15 16:32:03 Re: Securing records using linux grou permissions