| From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: : : How to mask column: : |
| Date: | 2019-01-29 08:55:52 |
| Message-ID: | cb3b1fa6-7e46-2f0d-97ae-a7040e87b24e@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mariel Cherkassky | 2019-01-29 08:57:11 | pg_locks - what is a virtualxid locktype |
| Previous Message | Thomas Kellerer | 2019-01-29 08:39:47 | Re: : : How to mask column: : |