pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed: : How to mask column: :
8+ messages / 6 participants
[nested] [flat]
* : : How to mask column: :
@ 2019-01-29 08:02 JD <venkijd@gmail.com>
0 siblings, 3 replies; 8+ messages in thread
From: JD @ 2019-01-29 08:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Team,
Is there any way to mask the column value (*******) in postgresql?
Cheer's
Venkat.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-29 08:14 Erkan Durmuş <derkan@gmail.com>
parent: JD <venkijd@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Erkan Durmuş @ 2019-01-29 08:14 UTC (permalink / raw)
To: JD <venkijd@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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's
> Venkat.
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-29 08:21 JD <venkijd@gmail.com>
parent: Erkan Durmuş <derkan@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: JD @ 2019-01-29 08:21 UTC (permalink / raw)
To: Erkan Durmuş <derkan@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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's
>> Venkat.
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-29 08:39 Thomas Kellerer <spam_eater@gmx.net>
parent: JD <venkijd@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Thomas Kellerer @ 2019-01-29 08:39 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-29 08:55 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 0 replies; 8+ messages in thread
From: Achilleas Mantzios @ 2019-01-29 08:55 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-29 09:35 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: JD <venkijd@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Shreeyansh Dba @ 2019-01-29 09:35 UTC (permalink / raw)
To: JD <venkijd@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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/
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
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's
> Venkat.
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-30 00:25 Bear Giles <bgiles@coyotesong.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Bear Giles @ 2019-01-30 00:25 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: JD <venkijd@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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/
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> 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's
>> Venkat.
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: : : How to mask column: :
@ 2019-01-30 07:47 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Bear Giles <bgiles@coyotesong.com>
0 siblings, 0 replies; 8+ messages in thread
From: Shreeyansh Dba @ 2019-01-30 07:47 UTC (permalink / raw)
To: Bear Giles <bgiles@coyotesong.com>; +Cc: JD <venkijd@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
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/
>>
>> Thanks & Regards,
>> *Shreeyansh DBA Team*
>> www.shreeyansh.com
>>
>>
>> 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's
>>> Venkat.
>>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2019-01-30 07:47 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-29 08:02 : : How to mask column: : JD <venkijd@gmail.com>
2019-01-29 08:14 ` Erkan Durmuş <derkan@gmail.com>
2019-01-29 08:21 ` JD <venkijd@gmail.com>
2019-01-29 08:39 ` Thomas Kellerer <spam_eater@gmx.net>
2019-01-29 08:55 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2019-01-29 09:35 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-30 00:25 ` Bear Giles <bgiles@coyotesong.com>
2019-01-30 07:47 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
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