Re: Feature idea: Dynamic Data Making

From: Joe Conway <mail(at)joeconway(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Riccardo Bassani <riccardo(dot)work(dot)86(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Feature idea: Dynamic Data Making
Date: 2017-12-10 17:02:27
Message-ID: f636be0e-3d87-a5df-c32b-704eeb2990bf@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/05/2017 01:03 PM, Alvaro Herrera wrote:
> Riccardo Bassani wrote:
>> As SQL Server 2016 (
>> https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
>> ) , or Oracle does: it could be a neat feature having Dynamic Data
>> Masking, even if it has some limitations, it could help in the
>> application development, imho.
>>
>> I know it's possible to put this logic in the application (if you look
>> in internet for "spring framework data masking" you find a lot of
>> results).
>>
>> What do you think?
>> I know there is more important things to do (like partitioning or
>> parallelism), but it could be neat to see that in a future release .
>
> Data masking is pretty important actually. Since you seem to have an
> interest in seeing it done, care to submit a patch?

I was recently discussing this with some other hackers, and the
consensus seemed to be that this should be implemented with a new kind
of POLICY that operates at the field level. We didn't go into much
detail beyond that though.

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim Gündüz 2017-12-10 19:26:33 Re: Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo.
Previous Message Stefan Keller 2017-12-10 13:16:01 Re: PG Schema to be used as log and monitoring store