Обсуждение: : : How to mask column: :

Поиск
Список
Период
Сортировка

: : How to mask column: :

От
JD
Дата:
Hi Team,

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

Cheer's
Venkat.

Re: : : How to mask column: :

От
Erkan Durmuş
Дата:

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.

Re: : : How to mask column: :

От
JD
Дата:
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:

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.

Re: : : How to mask column: :

От
Thomas Kellerer
Дата:
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. 




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



Re: : : How to mask column: :

От
Shreeyansh Dba
Дата:
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.

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 <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.

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 <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.