Postgres Pro
Downloads
Home   >   mailing lists

Re: security labels or sensitivity markings - Mailing list pgsql-general

From Geoff Montee
Subject Re: security labels or sensitivity markings
Date
Msg-id CAA7biFMTqazGdVQFcKubuQQZ=PedQAaFWdTApFNpXTYvhQGVXw@mail.gmail.com
Whole thread Raw
In response to security labels or sensitivity markings  (sumita <suday@avaya.com>)
List pgsql-general
Tree view



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:


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


pgsql-general by date:

Previous
From: sumita
Date:
Subject: security labels or sensitivity markings
Next
From: Marc Mamin
Date:
Subject: operator is not unique: smallint[] @> smallint[] You might need to add explicit type casts (!)