security labels or sensitivity markings
Does postgresql support the use of security labels or sensitivity markings?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/security-labels-or-sensitivity-markings-tp5811425.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jul 14, 2014 at 2:23 AM, sumita <suday@avaya.com> wrote:
Does postgresql support the use of security labels or sensitivity
markings?
If what you want is some kind of row-level security, you have to roll your
own when using PostgreSQL. Security_barrier views are a good option for
this. See:
http://blog.2ndquadrant.com/how-do-postgresql-security_barrier-views-work/
PostgreSQL 9.4 (out in a couple months) will be enhancing security_barrier
views, so they will also be updatable without requiring the use of triggers.
Geoff
* sumita (suday@avaya.com) wrote:
Does postgresql support the use of security labels or sensitivity markings?
For tables, yes, but not yet for rows/RLS. There is ongoing work in
this area and the hope is that there will be some form of RLS in 9.5.
As mentioned, security barrier views can be used as a work-around for
existing releases.
Thanks,
Stephen