Thread: : : How to mask column: :
Hi Team,
Is there any way to mask the column value (*******) in postgresql?
Cheer's
Venkat.
I've not tried but https://gitlab.com/dalibo/postgresql_anonymizer may help.
On Tue, Jan 29, 2019 at 11:02 AM JD <venkijd@gmail.com> wrote:
Hi Team,Is there any way to mask the column value (*******) in postgresql?Cheer'sVenkat.
Thanks very much, Let me check at my end. This will helpful.
Cheer's
Venkat.
On Tue, Jan 29, 2019 at 1:44 PM Erkan Durmuş <derkan@gmail.com> wrote:
I've not tried but https://gitlab.com/dalibo/postgresql_anonymizer may help.On Tue, Jan 29, 2019 at 11:02 AM JD <venkijd@gmail.com> wrote:Hi Team,Is there any way to mask the column value (*******) in postgresql?Cheer'sVenkat.
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.
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
Hi JD
There is another link regarding Masking Data With PostgreSQL.
Hope this will helps you.
https://blog.dbi-services.com/masking-data-with-postgresql/
There is another link regarding Masking Data With PostgreSQL.
Hope this will helps you.
https://blog.dbi-services.com/masking-data-with-postgresql/
On Tue, Jan 29, 2019 at 1:32 PM JD <venkijd@gmail.com> wrote:
Hi Team,Is there any way to mask the column value (*******) in postgresql?Cheer'sVenkat.
Can RLS or CLS be treated as a SELECT trigger, or is it too coarse for that?
I agree with the suggestion to use a view if possible. I know it might not be viable if you use an object-relational model abstraction layer implementation that provides heavy caching.
On Tue, Jan 29, 2019 at 2:35 AM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
Hi JD
There is another link regarding Masking Data With PostgreSQL.
Hope this will helps you.
https://blog.dbi-services.com/masking-data-with-postgresql/On Tue, Jan 29, 2019 at 1:32 PM JD <venkijd@gmail.com> wrote:Hi Team,Is there any way to mask the column value (*******) in postgresql?Cheer'sVenkat.
Row-level security must be enabled on the table by using ALTER TABLE... ENABLE ROW LEVEL SECURITY in order for creating policies to be applied. If row-level security is enabled for a table, but no applicable policies exist, a default deny policy is assumed that no rows will be visible or updatable.
On Wed, Jan 30, 2019 at 5:55 AM Bear Giles <bgiles@coyotesong.com> wrote:
Can RLS or CLS be treated as a SELECT trigger, or is it too coarse for that?I agree with the suggestion to use a view if possible. I know it might not be viable if you use an object-relational model abstraction layer implementation that provides heavy caching.On Tue, Jan 29, 2019 at 2:35 AM Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:Hi JD
There is another link regarding Masking Data With PostgreSQL.
Hope this will helps you.
https://blog.dbi-services.com/masking-data-with-postgresql/On Tue, Jan 29, 2019 at 1:32 PM JD <venkijd@gmail.com> wrote:Hi Team,Is there any way to mask the column value (*******) in postgresql?Cheer'sVenkat.