Re: : : How to mask column: :

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(at)coyotesong(dot)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(at)gmail(dot)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(at)gmail(dot)com> wrote:
>>
>>> Hi Team,
>>>
>>> Is there any way to mask the column value (*******) in postgresql?
>>>
>>> Cheer's
>>> Venkat.
>>>
>>