Postgres Pro
Downloads
Home   >   mailing lists

Re: Securing records using linux grou permissions - Mailing list pgsql-general

From David Gauthier
Subject Re: Securing records using linux grou permissions
Date
Msg-id CAMBRECB=12dpQSREXmRHeeayXjY_FZG5cmNddetHsJBmqX52pg@mail.gmail.com
Whole thread Raw
In response to Re: Securing records using linux grou permissions  (Michael Lewis <mlewis@entrata.com>)
Responses Re: Securing records using linux grou permissions
Re: Securing records using linux grou permissions
List pgsql-general
Tree view
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@entrata.com> wrote:
It sounds like you want row level security-

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.

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Securing records using linux grou permissions
Next
From: Ron
Date:
Subject: Re: Securing records using linux grou permissions