From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: : : How to mask column: :
Date: Tue, 29 Jan 2019 10:55:52 +0200
Message-ID: <cb3b1fa6-7e46-2f0d-97ae-a7040e87b24e@matrix.gatewaynet.com> (raw)
In-Reply-To: <8a65c3aa-5059-d660-5d8c-523df82e7ea4@gmx.net>
References: <CABokaaPSrK6+FFAdfT8gg-mNLXB9612NezaCbTNRtC7HqztkKw@mail.gmail.com>
<8a65c3aa-5059-d660-5d8c-523df82e7ea4@gmx.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: : : How to mask column: :
In-Reply-To: <cb3b1fa6-7e46-2f0d-97ae-a7040e87b24e@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox