Re: Securing records using linux grou permissions

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

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 David Gauthier 2019-10-15 17:10:13 Re: Securing records using linux grou permissions
Previous Message Ray O'Donnell 2019-10-15 16:15:00 Re: SELECT returnig a constant