Re: : : How to mask column: : - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: : : How to mask column: :
Date
Msg-id cb3b1fa6-7e46-2f0d-97ae-a7040e87b24e@matrix.gatewaynet.com
Whole thread Raw
In response to Re: : : How to mask column: :  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-admin
On 29/1/19 10:39 π.μ., Thomas Kellerer wrote:
> JD schrieb am 29.01.2019 um 09:02:
>> Hi Team,
>>
>> Is there any way to mask the column value (*******) in postgresql?
> You could create a view that does that and only give access to that view, rather than the underlying table.
>
IMHO this should fall under RLS. Something that could be called CLS (Column Level Security). Dalibo's anonymizer seems
promising,if only it could be integrated in RLS framework . That would mean 
 
instant GDPR :)
>


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt



pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: : : How to mask column: :
Next
From: Mariel Cherkassky
Date:
Subject: pg_locks - what is a virtualxid locktype