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