: : How to mask column: :

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

: : How to mask column: :

jd-2
Hi Team,

Is there any way to mask the column value (*******) in postgresql? 

Cheer's
Venkat.
Reply | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

Erkan Durmuş

On Tue, Jan 29, 2019 at 11:02 AM JD <[hidden email]> wrote:
Hi Team,

Is there any way to mask the column value (*******) in postgresql? 

Cheer's
Venkat.
Reply | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

jd-2
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ş <[hidden email]> wrote:

On Tue, Jan 29, 2019 at 11:02 AM JD <[hidden email]> wrote:
Hi Team,

Is there any way to mask the column value (*******) in postgresql? 

Cheer's
Venkat.
Reply | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

Thomas Kellerer
In reply to this post by jd-2
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.



Reply | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

Achilleas Mantzios
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 | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

Shreeyansh dba
In reply to this post by jd-2
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 <[hidden email]> wrote:
Hi Team,

Is there any way to mask the column value (*******) in postgresql? 

Cheer's
Venkat.
Reply | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

Bear Giles
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 <[hidden email]> 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 <[hidden email]> wrote:
Hi Team,

Is there any way to mask the column value (*******) in postgresql? 

Cheer's
Venkat.
Reply | Threaded
Open this post in threaded view
|

Re: : : How to mask column: :

Shreeyansh dba
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> wrote:
Hi Team,

Is there any way to mask the column value (*******) in postgresql? 

Cheer's
Venkat.